As shown below, Connect CDC supports distribution of most Oracle datatypes. In the tables of supported datatypes in the following pages, the Numeric Length column shows the maximum supported number of numeric digits, while Display Length is the maximum number of characters, or the numeric length plus an included sign, if any.
An asterisk (*) means the length is taken from the column definition in the DBMS catalog. For decimal numeric types, the length is the number of positions to the left of the decimal point. For example, a NUMERIC(10,2) column has a length of 8.
|
Datatype |
Category |
Numeric Length |
DisplayLength |
|---|---|---|---|
|
BLOB ab |
Binary Large Object |
|
|
|
CHAR |
Character |
|
* |
|
CLOB ab |
Character Large Object |
|
|
|
DATE c |
Date/Interval |
|
26 |
|
FLOAT |
Unicode |
|
|
|
LONG ab |
Long Character |
|
|
|
LONG RAW ab |
Long Binary |
|
|
|
NCHAR d |
Unicode |
|
* |
|
NCLOB |
Unicode, Character Large Object e |
|
|
|
NUMBER (38) |
Integral Numeric |
38 |
39 |
|
NUMBER (no precision or scale) f |
FLOAT or INTEGER |
|
|
|
NUMBER (p,s) |
Decimal |
* |
|
|
NVARCHAR2 d |
Unicode |
|
* |
|
RAW |
Binary |
|
|
|
TIMESTAMP dgh |
Date/Interval |
|
26 |
|
VARCHAR2,CHARACTER VARYING |
Character |
|
* |
|
aFor distribution to Oracle and MS SQL Server targets only. See Distribute large objects. bBinary type or long type columns cannot be used in data enhancement, expressions or gate conditions. dSupported for Oracle 10g and later. eAdd the [Director] parameter OracleNCHARSupport=1 to the omnient.ini. fSee Handle NUMBER (no p,s) as FLOAT or INTEGER gSupported for 0 to 6 fractional seconds. hTIMESTAMP with Time Zone and TIMESTAMP with Local Time Zone datatypes are not supported. |