List of Figures

1-1 Embedded SQL Program Development

1-2 Pro*COBOL Features and Benefits

2-1 Application Development Process

2-2 Updating the SQLCA

3-1 Connecting Through Oracle

6-1 Maximum Cursors in Use

8-1 SQLSTATE Coding Scheme

8-2 SQLCA Variable Declarations for Pro*COBOL

8-3 ORACA Variable Declarations for Pro*COBOL

9-1 Choosing the Right Method

11-1 Sample Pro*COBOL SQLDA Descriptors and Data Buffers

11-2 How Variables Are Set

11-3 Initialized Select Descriptor

11-4 Initialized Bind Descriptor

11-5 Bind Descriptor after the DESCRIBE

11-6 Bind Descriptor after Assigning Values

11-7 Select Descriptor after the DESCR

11-8 Select Descriptor before the FETCH

11-9 Select Descriptor after the FETCH

12-1 Loosely Coupling Connections and Threads

12-2 Context Sharing Among Threads

12-3 No Context Sharing Among Threads

C-1 PL/SQL Boosts Performance

C-2 Cursors Linked through the Cursor Cache