Oracle Call Interface

Oracle Call Interface

In computing, the Oracle Call Interface (OCI) consists of a set of C-language software APIs which provide an interface to the Oracle database.

OCI offers a procedural API for not only performing certain database administration tasks (such as system startup and shutdown), but also for using PL/SQL or SQL to query, access, and manipulate data. The OCI library, based on Oracle's undocumented User Programmatic Interface (UPI), acts as an "interpreter" between applications and the low-level database network protocol.

Contents

History

Oracle Corporation first released OCI (under the name HLI, the Host Language Interface) with Oracle Database version 6 in 1988. As HLI (and subsequently OCI) operated as wrappers for UPI, their original naming conventions closely resembled those of the UPI calls they were based upon. For example, the rollback statement: the call upirol in UPI became orol in OCI.

Later, in Oracle8 (released in 1997), OCI calls acquired more descriptive names; orol became OCITransRollback. Subsequent improvements have been made in every version of OCI, including 11g (released in 2007). Oracle Corporation claims that OCI is "So reliable that every SQL statement in the Oracle Database executes with OCI".

Implementations

OCI is so popular that, in addition to Oracle, several other vendors have implemented their own libraries compatible with the OCI API. To date, OCI-compatible libraries exist for the ANTs Data Server[citation needed] (ADS), EnterpriseDB, and the Linter SQL RDBMS.

OCI-based libraries

Several libraries are based on top of OCI, including:

Due to the complexity of the OCI API, several easier-to-use OCI wrapper libraries also exist, such as:

External links



Wikimedia Foundation. 2010.

Игры ⚽ Поможем написать курсовую

Look at other dictionaries:

  • Oracle Call Interface — Das Oracle® Call Interface (OCI) ist ein API zum Zugriff auf einen Oracle Datenbankserver. Das API ermöglicht lesende und modifizierende Zugriffe auf die Daten und deren Struktur, das Datenbankschema. Die Schnittstelle ist für die… …   Deutsch Wikipedia

  • Oracle C++ Call Interface — The Oracle C++ Call Interface (OCCI), as defined by the database company Oracle Corporation, offers C++ programmers a comfortable interface to access Oracle databases. The OCCI classes have parameters reminiscent of SQL statements. The interface… …   Wikipedia

  • Oracle Data Mining — (ODM) is an option of Oracle Corporation s Relational Database Management System (RDBMS) Enterprise Edition (EE). It contains several data mining and data analysis algorithms for classification, prediction, regression, classification,… …   Wikipedia

  • User Programmatic Interface — In computing, the User Programmatic Interface (UPI), also known as the User Program Interface, consists of a set of C language software APIs which provide the lowest level API based interface to the Oracle database.OverviewUPI offers a procedural …   Wikipedia

  • Oracle Corporation — Type Public Traded as NYSE: ORCL NASDAQ:  …   Wikipedia

  • Interface (computing) — For other uses, see Interface. In the field of computer science, an interface is a tool and concept that refers to a point of interaction between components, and is applicable at the level of both hardware and software. This allows a component,… …   Wikipedia

  • Call centre — A very large collections call centre in Lakeland, Florida. A call centre or call center is a centralised office used for the purpose of receiving and transmitting a large volume of requests by telephone. A call centre is operated by a company to… …   Wikipedia

  • Java Native Interface — JNI redirects here. For the city in the province of Buenos Aires, see Junín, Buenos Aires. The Java Native Interface (JNI) is a programming framework that enables Java code running in a Java Virtual Machine (JVM) to call and to be called[1] by… …   Wikipedia

  • Unified Extensible Firmware Interface — UEFI Logo Extensible Firmware Interface s position in the software stack …   Wikipedia

  • OCI — Oracle Call Interface (Computing » Databases) * On Campus Interviews (Academic & Science » Universities) * On Campus Interviewing (Business » Positions) * Organization of the Islamic Conference (Community » Religion) * Object Computing, Inc.… …   Abbreviations dictionary

Share the article and excerpts

Direct link
Do a right-click on the link above
and select “Copy Link”