Oracle Programming with Pro*C/C++ or Pro*COBOL

Course Number:  576-JK
Recommended Duration:  2 days

Intended Audience
Programmers who will be writing C, C++, or COBOL programs that access the Oracle database.

Course Overview
Covers embedded SQL, error handling, nulls, data matching, arrays, PL/SQL, cursors, and exits.  There are six machine exercises.

Course appropriate for Pro*C/C++ or Pro*COBOL.  Course may be modified to cover earlier releases.

Objectives
Participants will design, code, and test C, C++, or COBOL language programs using embedded SQL statements to access the Oracle database.  Hands-on exercises provide practice with the Oracle Pro* programmatic interfaces.

Prerequisites
Experience using the third-generation language (C, C++, COBOL, PL/I, etc...) to be used for the exercises.  Familiarity with Oracle and SQL is required.

Topics

• Embedded SQL syntax differences

• Pro* precompiler

• Precompiler options

• Static SQL and Dynamic SQL

• Host/Bind Variable declaration

• Using Host/Bind variables

• Null data values

• Cursors

• Oracle array interfaces

• Using SQLCA

• Using ORACA

• Error handling

• Embedded PL/SQL

• Using PL/SQL Stored Procedures, Functions, and Packages
• Performance issues