Oracle Call Interface (OCI)

OCI is an application programming interface (API) that enables you to communicate with the database server. An OCI consists of a function library that you can call from an application program to run SQL statements and communicate with the data source.

The OCI functions in a way to let the LN Oracle database driver calls perform these actions:

• Connects to Oracle (opens the session).
• Allocates cursors.
• Parses an SQL statement.
• Binds input variables.
• Defines output variables.
• Runs an SQL statement.
• Fetches the resulting rows.
• Commits or aborts a transaction.
• Closes, unbinds, and drops a cursor.
• Disconnects from Oracle (closes the session).

The LN Oracle driver also uses these features of OCI:

• Array fetches (if enabled).
• Array inserts (if enabled and if possible).