Oracle Programming with Pro*C/C++ or Pro*COBOL
- Recommended Duration:
- 2 Days
- Version
- Pro*C/C++ or Pro*COBOL. Course may be modified to cover earlier releases or other languages.
- Benefits
- 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.
- Audience
- Programmers who will be writing C, C++, or COBOL programs that access the Oracle database.
- 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.
- Major 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
- Exercises
- There are six machine exercises.