Part 2: The 32-Bit/64-Bit Drivers : The Oracle Driver : Connection Option Descriptions : Catalog Options

Catalog Options
Attribute
CatalogOptions (CO)
Purpose
Determines whether SQL_NULL_DATA is returned for the result columns REMARKS and COLUMN_DEF.
Valid Values
0 | 1
Behavior
If set to 1 (Enabled), the result column REMARKS (for the catalog functions SQLTables and SQLColumns) and the result column COLUMN_DEF (for the catalog function SQLColumns) return actual values. Enabling this option reduces the performance of your catalog (SQLColumns and SQLTables) queries.
If set to 0 (Disabled), SQL_NULL_DATA is returned for the result columns REMARKS and COLUMN_DEF.
Notes
Default
0 (Disabled)
GUI Tab
Advanced tab
See Also
See Performance Considerations for details.

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