Data Type Mapping
Data Type Mappings
The provider maps types from the data source to the corresponding data type available in the schema. The table below documents these mappings.
Note: The provider supports reading user-defined data types (UDTs). Parameters with a UDT are mapped to the most analogous SQL type and returned as the "DATA_TYPE" in the ProcedureParameters schema collection (see Procedure Parameters).
| TYPE_CHAR | varchar |
| TYPE_VARCHAR2 | varchar |
| TYPE_NCHAR | varchar |
| TYPE_NVARCHAR2 | varchar |
| TYPE_CLOB | clob |
| TYPE_NCLOB | varchar |
| TYPE_LONG | varchar |
| TYPE_NUMBER | decimal |
| TYPE_DATE | datetime |
| TYPE_TIMESTAMP | datetime |
| TYPE_TIMESTAMP_WITH_TIMEZONE | datetime |
| TYPE_TIMESTAMP_WITH_LOCAL_TIMEZONE | datetime |
| TYPE_INTERVAL_YEAR_TO_MONTH | interval year (year precision) to month |
| TYPE_INTERVAL_DAY_TO_SECOND | interval day (day precision) to second (fractional seconds precision) |
| TYPE_BLOB | binary |
| TYPE_BFILE | binary |
| TYPE_RAW | binary |
| TYPE_ROWID | rowid |
| TYPE_UROWID | urowid |
| TYPE_BINARY_FLOAT | real |
| TYPE_BINARY_DOUBLE | float |