Datatype Conversion

Datatype Equivalencing

Embedding PL/SQL

Cursor Variables

Connecting to Oracle

2 Error Handling and Diagnostics< /a>

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: Dyna mic 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 Varia bles 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-S pecific References for Chapter 1

System-Specific Reference for Chapter 3

System-Specific Reference for Chapter 4

Next

Copyright © 1996, 2002 Oracle Corporation
All Rights Reserved.

Home
Book List
Index
Master Index
Feedback

Contents

Preface

1 Writing a Pro*FORTRAN Program

2 Error Handling and Diagnostics< /a>

3 Sample Programs

4 Implementing Dynamic SQL Method 4

A Operating System Dependencies