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

• Writing a Pro*FORTRAN Program
  • Programming Guidelines
  • Required Declarations and SQL Statements
  • Host Variables
  • Indicator Variables
  • Host Arrays
  • VARCHAR Host 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)
  • Using the SQLDA Variables and Arrays
  • Some Preliminaries
  • The Basic Steps
  • A Closer Look at Each Step
  • Using Host Arrays with Method 4
  • Sample Program 10: Dynamic SQL Method 4

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