Connectors > Oracle

Oracle Type	DTS Type
BOOLEAN	BOOLEAN
CHAR	STRING
NCHAR	STRING
VARCHAR	STRING
VARCHAR2	STRING
NVARCHAR2	STRING
ROWID	STRING
UROWID	STRING
MLSLABEL	STRING
RAW	BINARY
INTEGER	INT32
INT	INT32
SMALLINT	INT32
NUMBER	DECIMAL
NUMERIC	DECIMAL
DECIMAL	DECIMAL
FLOAT	DOUBLE
REAL	FLOAT
DOUBLE PRECISION	DOUBLE
DATE	DATE
TIMESTAMP	DATE_TIME
TIMESTAMP WITH TIMEZONE	DATE_TIME
TIMESTAMP WITH LOCAL TIMEZONE	DATE_TIME
INTERVAL YEAR TO MONTH	STRING
INTERVAL DAY TO SECOND	STRING
TIME	TIME
MDSYS.SDO_GEOMETRY	DTS_GEOMETRY

The DTS Oracle Connector also supports the following categories of User-Defined Types:

•Object Types: any Oracle object type is supported as long as its individual field types are also supported;

•Collection Types: VARRAYs of native and Object Types are fully supported.

•Type Inheritance is fully supported;

•Aliases are fully supported for type naming;

Currently Unsupported Native Types:

BLOB, CLOB, NCLOB, LONG RAW, BFILE, CFILE, XMLTYPE