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 EDB implementation of the Open Client Library is written in C.

• Installing and Configuring the OCL Connector
  • Installing the Connector with an RPM Package
    • On RHEL 7
    • On RHEL 8
    • On CentOS 7
    • On CentOS 8
    • Updating an RPM Installation
  • Installing the Connector on an SLES 12 Host
  • Installing the Connector 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
• OTL Support
  • OTL Certification
  • Examples
    • Connect and Login
    • CREATE TABLE, INSERT, and SELECT
    • UPDATE
    • Stored Procedure
    • Function
    • REF CURSOR