Trusted answers to developer questions
Trusted Answers to Developer Questions

Related Tags

oracle
oci
databases

What is Oracle Call Interface?

Anusheh Zohair Mustafeez

Grokking Modern System Design Interview for Engineers & Managers

Ace your System Design Interview and take your career to the next level. Learn to handle the design of applications like Netflix, Quora, Facebook, Uber, and many more in a 45-min interview. Learn the RESHADED framework for architecting web-scale applications by determining requirements, constraints, and assumptions before diving into a step-by-step design process.

The Oracle Call Interface (OCI) is a native C language API that allows for​ the creation of applications that can be used to manipulate data and schemas in an Oracle database. OCI supports datatypes, calling conventions, syntax, and semantics of various third-generation languages such as C, C++, COBOL, and FORTRAN.

svg viewer

Applications

Since OCI is highly reliable, it is used by several Oracle tools, including SQL*Plus, Real Application Testing (RAT), and Data-Pump. Language-specific interfaces like Oracle JDBC-OCI, Oracle Precompilers, and Oracle C++ Call Interface (OCCI) drivers are also built upon the OCI. The API is used by the R language’s ROracle driver and other leading scripting language drivers such as node-oracledb, for Node.js, and PHP OCI8.

Functionality

OCI libraries provide the following functionality:

  • Accessing objects on the Oracle server using SQL.
  • Accessing, manipulating, and managing objects in the object cache by traversing pointers or REFs.
  • Converting Oracle dates, strings, and numbers to C data types.
  • Managing the size of the object cache’s memory.

RELATED TAGS

oracle
oci
databases

CONTRIBUTOR

Anusheh Zohair Mustafeez
Copyright ©2022 Educative, Inc. All rights reserved

Grokking Modern System Design Interview for Engineers & Managers

Ace your System Design Interview and take your career to the next level. Learn to handle the design of applications like Netflix, Quora, Facebook, Uber, and many more in a 45-min interview. Learn the RESHADED framework for architecting web-scale applications by determining requirements, constraints, and assumptions before diving into a step-by-step design process.

Keep Exploring