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.