B
OCI Demonstration Programs

Oracle provides code examples illustrating the use of OCI calls. These programs are provided for demonstration purposes, and are not guaranteed to run on all platforms.

The demonstration programs are available with your Oracle installation. The location, names, and availability of the programs may vary on different platforms. On a Unix workstation, the programs are installed in the ORACLE_HOME/demo directory. On a Windows NT machine, the programs are located in the ORACLE_HOME\Oci\Samples directory.

When a specific header or SQL file is required by the application, these files are also included. Review the information included at the beginning of the demonstration programs for setups and hints on running the programs.

Table B-1, "OCI Demonstration Programs" lists the important demonstration programs and the OCI features that they illustrate.

Table B-1 OCI Demonstration Programs

Program Name Features Illustrated

cdemo1.c

Using basic SQL processing

cdemo81.c

Using basic SQL processing with release 8 functionality

cdemo82.c

Performing basic processing of user-defined objects

cdmocor.c

Using complex object retrieval (COR) to improve performance

cdemodr1.c, cdemodr2.c, cdemodr3.c

Using INSERT/UPDATE/DELETE statements with RETURNING clause used with LOBs and REFs

cdemodsa.c

Describing information about a table

cdemodsc.c

Describing information about a user-defined type

cdemofo.c

Registering and operating application failover callbacks

cdemolb.c

Creating, accessing, and manipulating LOB objects

cdemolb2.c

Writing and reading of CLOB/BLOB columns with stream mode and callback functions

cdemolbs.c

Writing and reading to LOBs with the LOB buffering system

cdemobj.c

Pinning and navigation of REF object

cdemorid.c

Using INSERT/UPDATE/DELETE statements and fetches to get multiple Rowids in one roundtrip

cdemoses.c

Using session switching and migration

cdemothr.c

Using the OCIThread package

cdemosyev.c

Registering predefined subscriptions and specifying a callback function to be invoked for client notifications

cdemodp_lip.c

Loading data with the direct path load functions

cdemoucb.c, cdemoucbl.c

Using dynamic and static user callbacks

Program Name	Features Illustrated
cdemo1.c	Using basic SQL processing
cdemo81.c	Using basic SQL processing with release 8 functionality
cdemo82.c	Performing basic processing of user-defined objects
cdmocor.c	Using complex object retrieval (COR) to improve performance
cdemodr1.c, cdemodr2.c, cdemodr3.c	Using INSERT/UPDATE/DELETE statements with RETURNING clause used with LOBs and REFs
cdemodsa.c	Describing information about a table
cdemodsc.c	Describing information about a user-defined type
cdemofo.c	Registering and operating application failover callbacks
cdemolb.c	Creating, accessing, and manipulating LOB objects
cdemolb2.c	Writing and reading of CLOB/BLOB columns with stream mode and callback functions
cdemolbs.c	Writing and reading to LOBs with the LOB buffering system
cdemobj.c	Pinning and navigation of REF object
cdemorid.c	Using INSERT/UPDATE/DELETE statements and fetches to get multiple Rowids in one roundtrip
cdemoses.c	Using session switching and migration
cdemothr.c	Using the OCIThread package
cdemosyev.c	Registering predefined subscriptions and specifying a callback function to be invoked for client notifications
cdemodp_lip.c	Loading data with the direct path load functions
cdemoucb.c, cdemoucbl.c	Using dynamic and static user callbacks

B OCI Demonstration Programs

B
OCI Demonstration Programs