product logo Oracle Call Interface
So reliable that every SQL statement in the Oracle Database executes with OCI.
General Information

When applications developers demand the most powerful interface to the Oracle Database Server, they call upon the Oracle Call Interface (OCI). OCI provides the most comprehensive access to all of the Oracle Database functionality. The newest performance, scalability, and security features appear first in the OCI API.

A broad range of customers employ OCI including:

  • Large Fortune 500 customers developing complex database applications.
  • ISVs tailoring the Oracle Database to suit their needs

If you write applications for the Oracle Database, you likely already depend on OCI.  Some types of applications that depend upon OCI are:

  • PL/SQL applications executing SQL
  • C++ applications using OCCI
  • Java applications using the OCI-based JDBC driver
  • C applications using the ODBC driver
  • VB applications using the OLEDB driver
  • .NET applications using the ODP.NET driver
  • Pro*C applications
  • Distributed SQL

OCI in Oracle 11g has new features in scalability, performance and diagnosability areas. Some of them are:

  • Database Resident Connection Pooling
  • Client side Result Cache
  • Runtime Connection Load Balancing
  • Binding and Defining Multiple Buffers
  • Prefetching of LOB data
  • Drop-in compatibility with 10g
  • Fault Diagnosability

New features for OCI in Oracle 10g include:

  • Instant Client and Instant Client Light
  • IEEE 754 floating point number support (binary_float/binary_double)
  • Unlimited size LOB support
  • High Availability Event Notification
  • Database DML/DDL Change Notification
  • Startup/Shutdown Database

Instant Client gives ISVs and customers the ability to quickly install and deploy Oracle applications without any of the hassle. Please see the Instant Client site for more information.

Key benefits of OCI include:

  • Instant availability and leverageability of the latest Oracle Database server features
  • Enterprise level performance and scalability
  • A robust security model
  • Portability across all platforms running Oracle

The Oracle OCI features include significant improvements in performance and ease of use and other major enhancements. The wide product usage and strong integration with the database, backed by a strong growing engineering organization, make it the language of choice for developing secure, performance critical, data intensive applications that can easily scale to meet the needs of your enterprise.

Technical Information
Tech Info Divider.
Oracle Database 11g
NEW! Database Resident Connection Pooling (DRCP) (PDF)
Oracle Database 10g
Using Microsoft Intellisense for OCI in Oracle 10g
Transparent Application Failover
Oracle Database 9i
Oracle9i Database Release 2 New Data Access Features
Oracle9i Database Release 1 New Data Access Features
OCI Scrollable Cursors (PDF)
Boosting SQL Performance with cursor_sharing (PDF)
 
Left Curve
Related Technologies
Right Curve
 · Instant Client
 · OCCI
 · Net Services

Left Curve
More Information
Right Curve
 · FAQ
 · Client-Server Version Interoperability
 · Documentation

Left Curve
Discussion Forums
Right Curve
 · OCI
 · OCCI
 · Instant Client
E-mail this page
Printer View Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Privacy