Send to a Friend
 
Content to send

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

Share with others

Please provide the following information
Your Name
Your Email Address
Recipient Emails
Message

Can't Read? Click to Generate New Code
Enter the verification code shown above into the text box below