Schedule today!

Call Peggy at
  (800) 252-0652


Contact Us

More Oracle

Related Courses

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.