Pro*FORTRAN Supplement to the Oracle Precompilers Guide
Release 7.3
A42523-01
Library
Product
Index
Pro*FORTRAN
®
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 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
Copyright © 1996 Oracle Corporation
500 Oracle Parkway, Redwood City, CA 94065
Library
Product