Content to send
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
|
|
|
|
|
|
|
|