Data Type Mapping in Rowsets and Parameters

In rowsets and as parameter values, the OLE DB Provider for Oracle represents Oracle data by using the following OLE DB defined data types.

Oracle Server Data Type OLE DB Data Type
CHAR DBTYPE_STR
DATE DBTYPE_DBTIMESTAMP
FLOAT DBTYPE_R8
INTEGER DBTYPE_NUMERIC
LONG DBTYPE_STR
LONG RAW DBTYPE_BYTES
NUMBER DBTYPE_NUMERIC (in most cases)

DBTYPE_VARNUMERIC (when scale is negative, precision is not specified in the column definition, or scale is larger than what will fit into DBTYPE_NUMERIC)

RAW DBTYPE_BYTES
VARCHAR2 DBTYPE_STR

Note   The OLE DB Provider for Oracle does not support the Oracle MLSLABEL data type.