Oracle OCI Support

OpenESQL provides an alternative for developers using ORACLE data sources, in the form of the ORACLE OCI interface. To use this interface, you must compile your applications with the following directive:

sql(targetdb=ORACLEOCI)

When connecting to the Oracle server, use an Oracle Net8 service name in place of an ODBC data source name in the CONNECT statement. See your Oracle documentation on how to set up ORACLE Net8 services.

When you use Oracle OCI, be aware that the following OpenESQL functions are not supported:

• BEGIN TRANSACTION statement
• CALL statement
• EXECSP statement
• QUERY ODBC statement
• SET AUTOCOMMIT statement
• SET TRANSACTION ISOLATION statement
• Scrolling cursors (including SET SCROLLOPTION and SET CONCURRENCY statements)
• WITH PROMPT parameter on CONNECT statement (not available on UNIX)
• SQL (CONNECTIONPOOL) directive
• Switching connections using the SET CONNECTION statement
• SQL statements that contain DBCS characters