Content deleted Content added
m WP:CHECKWIKI error fix for #03. Missing Reflist. Do general fixes if a problem exists. - |
Removing link(s) to "User Programmatic Interface": Removing links to deleted page User Programmatic Interface. |
||
| (3 intermediate revisions by 3 users not shown) | |||
Line 4:
}}
In computing, the '''Oracle Call Interface''' ('''OCI''') consists of a set of [[C (programming language)|C]]-language
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
==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 (data management)|rollback]] statement: the call <code>upirol</code> in UPI became <code>orol</code> in OCI.
Later, in Oracle8 (released in 1997), OCI calls acquired more descriptive names; <code>orol</code> became <code>OCITransRollback</code>. 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".<ref>{{cite web |url=http://www.oracle.com/technology/tech/oci/index.html |url-status=dead |archive-url=https://web.archive.org/web/20040906134523/http://www.oracle.com/technology/tech/oci/index.html |archive-date=2004-09-06 |title=Oracle Call Interface}}</ref>
==Implementations==
OCI is so popular that, in addition to [[Oracle Corporation|Oracle]], several other vendors have implemented their own libraries compatible with the OCI API. To date, OCI-compatible libraries exist for the
==OCI-based libraries==
Line 30:
Due to the complexity of the OCI API, several easier-to-use OCI wrapper libraries also exist, such as:
* the open-source
* the open-source [[Ocilib|OCILIB]] library.
* the [[BSD license|Open BSD licensed]]
==References==
| |||