Open Client Library

The Open Client Library provides application interoperability with the Oracle Call Interface - an application that was formerly locked in can now work with either an EDB Postgres Advanced Server or an Oracle database with minimal to no changes to the application code.

The following diagram compares the Open Client Library and Oracle Call Interface application stacks.

Comparison with Oracle Call Interface

The EnterpriseDB implementation of the Open Client Library is written in C.

• Installing and Configuring the OCL Connector
  • Installing the Connector with an RPM Package
    • Updating an RPM Installation
  • Installing the Connector on an SLES 12 Host
  • Installing a DEB Package on a Debian or Ubuntu Host
  • Using the Graphical Installer to Install the Connector
• Forming a Connection String
• Compiling and Linking a Program
• Ref Cursor Support
• OCL Function Reference
  • Connect, Authorize and Initialize Functions
    • Using the tnsnames.ora File
  • Handle and Descriptor Functions
    • EDB_ATTR_EMPTY_STRINGS
    • EDB_ATTR_HOLDABLE
    • EDB_HOLD_CURSOR_ACTION
    • EDB_ATTR_STMT_LVL_TX
  • Bind, Define and Describe Functions
  • Statement Functions
  • Transaction Functions
  • XA Functions
    • xaoSvcCtx
  • Date and Datetime Functions
  • Interval Functions
  • Number Functions
  • String Functions
  • Cartridge Services and File I/O Interface Functions
  • LOB Functions
  • Miscellaneous Functions
  • Supported Data Types
• OCL Error Codes – Reference
• Multithreading Support