skip to main content
Using the Driver : Using Catalog Tables
  

Try DataDirect Drivers Now

Using Catalog Tables

The Oracle Service Cloud driver provides a standard set of catalog tables that maintain the information returned by various ODBC catalog functions such as SQLTables, SQLColumns, SQLDescribeParam and SQLDescribeCol. If possible use the ODBC catalog functions to obtain this information instead of querying the catalog tables directly.
The driver also provides additional catalog tables that maintain metadata specific to the Oracle Service Cloud driver. This section defines the catalog tables that provide Oracle Service Cloud driver-specific information. The catalog tables are defined in the INFORMATION_SCHEMA schema.
In this section: 
* SYSTEM_CACHES Catalog Table
* SYSTEM_REMOTE_SESSIONS Catalog Table
* SYSTEM_SESSIONINFO Catalog Table
* SYSTEM_SESSIONS Catalog Table