Contents

Preface

1 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

2 Error Handling and Diagnostics

Error Handling Alternatives

Using Status Variables when MODE={ANSI|ANSI14}

Using the SQL Communications Area

Using the Oracle Communications Area

3 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

4 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

A Operating System Dependencies

System-Specific References for Chapter 1

System-Specific Reference for Chapter 3

System-Specific Reference for Chapter 4