Oracle Programming with Pro*C or Pro*COBOL
- Recommended Duration:
- 2 Days
- Version
- Pro*C/C++ Release 9.0 or Pro*COBOL Release 9.0. Course may be modified to cover earlier releases.
- 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 or COBOL programs that access the Oracle database.
- Prerequisites
- Experience using the third-generation language (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 and precompiler options
- Static SQL and Dynamic SQL
- Host Variable declaration and use
- Null data valuesÂ
- Cursors
- Oracle array interfaces
- Using SQLCA and ORACA
- Error handling
- Embedded PL/SQL
- Exercises
- There are six machine exercises.