Part 2: The 32-Bit/64-Bit Drivers : The Oracle Driver : Data Types

Data Types
The following table shows how the Oracle data types are mapped to the standard ODBC data types. Unicode Support lists Oracle to Unicode data type mappings.

1
Read-Only

2
Supported only on Oracle 10g and higher.

3
Valid when connecting to Oracle 8 servers; these data types support output parameters to stored procedures

4
Supported only on Oracle 9i and higher.

5
Supported only on Oracle 9i R2 and higher.

The Oracle driver does not support any object types (also known as abstract data types). When the driver encounters an object type during data retrieval, it will return an Unknown Data Type error (SQL State HY000).
See Retrieving Data Type Information for more information about data types.
XMLType
Examples

© 2013 Progress Software Corporation and/or its subsidiaries or affiliates.