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 in the comments 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

cdemo81.c

Using basic SQL processing with release 8 functionality.

cdemo82.c

Performing basic processing of user-defined objects.

cdemocor.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 an object 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 (for more information about Advanced Queuing, see Oracle8i Application Developer's Guide - Advanced Queuing).

cdemodp_lip.c

Loading data with the direct path load functions.

cdemoupk.c, cdemoup1.c, cdemoup2.c

Using dynamic user callbacks with multiple packages.

Program Name	Features Illustrated
cdemo81.c	Using basic SQL processing with release 8 functionality.
cdemo82.c	Performing basic processing of user-defined objects.
cdemocor.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 an object 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 (for more information about Advanced Queuing, see Oracle8i Application Developer's Guide - Advanced Queuing).
cdemodp_lip.c	Loading data with the direct path load functions.
cdemoupk.c, cdemoup1.c, cdemoup2.c	Using dynamic user callbacks with multiple packages.

B OCI Demonstration Programs

B
OCI Demonstration Programs