OCCI Sample Code

Oracle C++ Call Interface provides high-performance and comprehensive access to Oracle databases. It can be used to develop applications ranging from simple database applications to high-performance mid-tier applications, involving complex object-oriented data models.

These are packaged as zipped tar files. To extract the sample files, please use gunzip and tar on Unix, and WinZip on Windows.

Oracle 10g Release 2 Demos
Download (ZIP, 5KB)
These are the new samples for OCCI features in 10.2.0.1.0. Posted 06-Dec-2005

Oracle 10g Release 1 Demos
Download (ZIP, 28KB)
These are the demos shipped with Oracle 10.1.0.2.Posted 10-Feb-2004.

Oracle 9.2.0 Demos
Download (ZIP, 13KB)
This is a comprehensive set of OCCI demos shipped with Oracle 9.2.0, demonstrating the basic OCCI functionality. Posted on 30-Jun-2003.

Calling PLSQL functions/procedures
Download (ZIP, 3KB)
Demonstrates calling PL/SQL functions and procedures, using registerOutParam, setDataBufferArray methods, passing and retrieving parameters of basic datatypes, VARRAY, PLSQL Table and REF Cursor. Posted 30-Jun-2003.

Object Access
Download (ZIP, 4KB)
Demonstrates creating and retrieving Oracle Spatial data objects using OCCI. Posted 08-Aug-2003.