Pro*COBOL Supplement to the Oracle Precompilers

Library

Product

---

• Pro*COBOL^® Supplement to the Oracle^® Precompilers Guide

• Preface
  • What This Manual Has to Offer
  • Who Should Read This Manual?
  • What's New in This Edition?
  • How This Guide Is Organized
  • Conventions Used in This Manual
  • Your Comments Are Welcome

• Writing a Pro*COBOL Program
  • Programming Guidelines
  • Required Declarations and SQL Statements
  • Host Variables
  • Indicator Variables
  • Host Tables
  • VARCHAR Variables
  • Handling Character Data
  • The Oracle Datatypes
  • Datatype Conversion
  • Datatype Equivalencing
  • Embedding PL/SQL
  • Cursor Variables
  • Connecting to Oracle

• Error Handling and Diagnostics
  • Error Handling Alternatives
  • Using Status Variables when MODE={ANSI|ANSI14}
  • Using the SQL Communications Area
  • Using the Oracle Communications Area

• Sample Programs
  • Sample Program 1: Simple Query
  • Sample Program 2: Cursor Operations
  • Sample Program 3: Fetching in Batches
  • Sample Program 4: Datatype Equivalencing
  • Sample Program 5: Oracle Forms User Exit
  • Sample Program 6: Dynamic SQL Method 1
  • Sample Program 7: Dynamic SQL Method 2
  • Sample Program 8: Dynamic SQL Method 3
  • Sample Program 9: Calling a Stored Procedure

• Implementing Dynamic SQL Method 4
  • Meeting the Special Requirements of Method 4
  • Understanding the SQL Descriptor Area (SQLDA)
  • The SQLDA Variables
  • Some Preliminaries
  • The Basic Steps
  • A Closer Look at Each Step
  • Using Host Tables with Method 4
  • Sample Program 10: Dynamic SQL Method 4

• Operating System Dependencies
  • System-Specific References
  • System-Specific Reference

---

Copyright © 1996 Oracle Corporation 500 Oracle Parkway, Redwood City, CA 94065

Library

Product