Skip Headers

Pro*FORTRAN Supplement to the Oracle Precompilers Guide
Release 1.8

Part Number A42523-1
Go to Documentation Home
Go to Book List
Book List
Go to Index
Go to Master Index
Master Index
Go to Feedback page

Go to next page
View PDF



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