EDB OCL Connector Guide

The EDB OCL Connector provides an API similar to the Oracle Call Interface. Applications that are written to use the Oracle Call Interface may be recompiled using EDB’s OCL connector in order to interact with an Advanced Server database server.

This guide provides installation and usage instructions about:

• How to install the connector.

• How to form an Oracle style connection string.

• How to compile and link a program.

This guide also includes a reference section for the functions supported by Advanced Server.

Note

EDB does not support the use of the Open Client Library with Oracle Real Application Clusters (RAC) and Oracle Exadata; the aforementioned Oracle products have not been evaluated nor certified with this EDB product.

• What’s New
• Supported Platforms
• libpq Cross-version Compatibility
• Open Client Library
  • Installing and Configuring the OCL Connector
    • Installing the Connector with an RPM Package
    • 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
    • Handle and Descriptor Functions
    • Bind, Define and Describe Functions
    • Statement Functions
    • Transaction Functions
    • XA Functions
    • 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
• Generating the OCL Trace
• Security and Encryption
  • Using SSL
  • Scram Compatibility
• Conclusion