Table of Contents
- Title and Copyright Information
- Preface
-
1
Writing a Pro*FORTRAN Program
- 1.1 Programming Guidelines
- 1.2 Required Declarations and SQL Statements
- 1.3 Host Variable Names
- 1.4 Scope of Host Variables
- 1.5 Host Variables
- 1.6 About Referencing Host Variables
- 1.7 Indicator Variables
- 1.8 Host Arrays
- 1.9 VARCHAR Host Variables
- 1.10 About Handling Character Data
- 1.11 The Oracle Datatypes
- 1.12 Datatype Conversion
- 1.13 Datatype Equivalencing
- 1.14 Embedding PL/SQL
-
1.15
About Declaring a Cursor Variable
- 1.15.1 About Allocating a Cursor Variable
- 1.15.2 About Opening a Cursor Variable
- 1.15.3 About Opening Indirectly through a Stored PL/SQL Procedure
- 1.15.4 About Opening Directly from Your Pro*FORTRAN Application
- 1.15.5 Return Types
- 1.15.6 About Fetching from a Cursor Variable
- 1.15.7 About Closing a Cursor Variable
- 1.15.8 Restrictions
- 1.15.9 Error Conditions
- 1.15.10 Sample Programs
- 1.15.11 SAMPLE11.SQL
- 1.15.12 SAMPLE11.PFO
- 1.16 Connecting to Oracle
-
2
Error Handling and Diagnostics
- 2.1 Error Handling Alternatives
- 2.2 About Using Status Variables when MODE={ANSI|ANSI14}
-
2.3
About Using the SQL Communications Area
- 2.3.1 What's in the SQLCA?
- 2.3.2 About Declaring the SQLCA
- 2.3.3 Key Components of Error Reporting
- 2.3.4 Status Codes
- 2.3.5 Warning Flags
- 2.3.6 Rows-Processed Count
- 2.3.7 Parse Error Offset
- 2.3.8 Error Message Text
- 2.3.9 About Getting the Full Text of Error Messages
- 2.3.10 About Using the WHENEVER Statement
- 2.3.11 Scope
- 2.3.12 Careless Usage: Examples
- 2.4 About Using the Oracle Communications Area
-
3
Sample Programs
- 3.1 Sample Program 1: Simple Query
- 3.2 Sample Program 2: Cursor Operations
- 3.3 Sample Program 3: Fetching in Batches
- 3.4 Sample Program 4: Datatype Equivalencing
- 3.5 Sample Program 5: Oracle Forms User Exit
- 3.6 Sample Program 6: Dynamic SQL Method 1
- 3.7 Sample Program 7: Dynamic SQL Method 2
- 3.8 Sample Program 8: Dynamic SQL Method 3
- 3.9 Sample Program 9: Calling a Stored Procedure
-
4
Implementing Dynamic SQL Method 4
- 4.1 Meeting the Special Requirements of Method 4
- 4.2 Understanding the SQL Descriptor Area (SQLDA)
-
4.3
About Using the SQLDA Variables and Arrays
- 4.3.1 The N Variable
- 4.3.2 The F Variable
- 4.3.3 The S Array
- 4.3.4 The M Array
- 4.3.5 The C Array
- 4.3.6 The L Array
- 4.3.7 Select Descriptors
- 4.3.8 Bind Descriptors
- 4.3.9 The T Array
- 4.3.10 Select Descriptors
- 4.3.11 Bind Descriptors
- 4.3.12 The V Array
- 4.3.13 Select Descriptors
- 4.3.14 Bind Descriptors
- 4.3.15 The I Array
- 4.3.16 Select Descriptors
- 4.3.17 Bind Descriptors
- 4.3.18 The X Array
- 4.3.19 The Y Array
- 4.3.20 The Z Array
- 4.4 Some Preliminaries
- 4.5 The Basic Steps
-
4.6
A Closer Look at Each Step
- 4.6.1 Declare a Host String
- 4.6.2 Declare the SQLDAs
- 4.6.3 Set the Maximum Number to DESCRIBE
- 4.6.4 Initialize the Descriptors
- 4.6.5 Store the Query Text in the Host String
- 4.6.6 PREPARE the Query from the Host String
- 4.6.7 DECLARE a Cursor
- 4.6.8 DESCRIBE the Bind Variables
- 4.6.9 Reset Number of Placeholders
- 4.6.10 Get Values for Bind Variables
- 4.6.11 OPEN the Cursor
- 4.6.12 DESCRIBE the Select List
- 4.6.13 Reset Number of Select-List Items
- 4.6.14 Reset Length/Datatype of Each Select-List Item
- 4.6.15 FETCH Rows from the Active Set
- 4.6.16 Get and Process Select-List Values
- 4.6.17 CLOSE the Cursor
- 4.7 Using Host Arrays with Method 4
- 4.8 Sample Program 10: Dynamic SQL Method 4
- A Operating System Dependencies
- Index