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.