Virtual Book about 'ref cursor|cursor variable'

Table of Contents: Virtual Book about 'ref cursor|cursor variable'

This virtual book brings together the most relevant topics about 'ref cursor|cursor variable'. The topics are grouped into these categories:

Introductory information about 'ref cursor|cursor variable'.
Tasks related to 'ref cursor|cursor variable'.
Examples of 'ref cursor|cursor variable'.
Detailed reference information on 'ref cursor|cursor variable'.
Troubleshooting information about 'ref cursor|cursor variable'.
Index entries about 'ref cursor|cursor variable'.
Bibliography - links to PDF files for printing.

[Back to top]

Introductory Information about 'ref cursor|cursor variable'

This category includes definitions, overviews, concepts, restrictions, frequently asked questions, and explanations of how things work. This is where you should start if you are not familiar with this subject area.

Results in this section come from these books:

PL/SQL User's Guide and Reference
Pro*COBOL Precompiler Programmer's Guide
SQL*Module for Ada Programmer's Guide
SQLJ Developer's Guide and Reference

[ Next book ]

PL/SQL User's Guide and Reference

What Are Cursor Variables?

Why Use Cursor Variables?

Restrictions on Cursor Variables

[

Previous book

Next book

]

Pro*COBOL Precompiler Programmer's Guide

Restrictions on Cursor Variables

[

Previous book

Next book

]

SQL*Module for Ada Programmer's Guide

Restrictions on Cursor Variables

[

Previous book

Next book

]

SQLJ Developer's Guide and Reference

Overview of REF CURSOR Types

[Back to top]

Tasks Related to 'ref cursor|cursor variable'

This category includes how-to information, both detailed procedures and general usage information and guidelines. The tasks are listed alphabetically, with shortcut links that jump to places within the list. For example, if you want to find Creating, look for a link labeled CRE.

Shortcuts to Tasks

ALL BIN CLO CON DEC DEF FET FRE OPE USI

Allocating a Cursor Variable

Binding Ref Cursor Variables

Closing a Cursor Variable

Closing and Freeing a Cursor Variable

Closing the Cursor Variable

Controlling Cursor Variables

Declaring a Cursor Variable

Declaring and Opening Cursor Variables

Declaring Cursor Variables

Defining REF CURSOR Types

Fetching from a Cursor Variable

Fetching from the Cursor Variable

Freeing a Cursor Variable

Opening a Cursor Variable

Opening the Cursor Variable

Using Cursor Variables

Using Cursor Variables with the OCI (Release 7 Only)

[Back to top]

Examples of 'ref cursor|cursor variable'

This category includes sample procedure and sample code, to illustrate how to perform tasks or use features.

Results in this section come from these books:

Application Developer's Guide - Fundamentals
Application Developer's Guide - XML
JDBC Developer's Guide and Reference
Pro*COBOL Precompiler Programmer's Guide
SQL*Plus User's Guide and Reference
SQLJ Developer's Guide and Reference

[ Next book ]

Application Developer's Guide - Fundamentals

Examples of Cursor Variables

[

Previous book

Next book

]

Application Developer's Guide - XML

XSU Example 5: Generating XML from Procedure Return Values (REF CURSORS) (Java)

[

Previous book

Next book

]

JDBC Developer's Guide and Reference

Example: Accessing REF CURSOR Data

REF CURSORs--RefCursorExample.java

[

Previous book

Next book

]

Pro*COBOL Precompiler Programmer's Guide

Sample Program 11: Cursor Variables

[

Previous book

Next book

]

SQL*Plus User's Guide and Reference

Example 3-19 Using REFCURSOR Variables in Stored Procedures

Example 3-20 Using REFCURSOR Variables in Stored Functions

[

Previous book

Next book

]

SQLJ Developer's Guide and Reference

REF CURSOR Example

REF CURSOR Sample Application Source Code

REF CURSOR--RefCursDemo.sqlj

[Back to top]

Detailed Reference Information on 'ref cursor|cursor variable'

This category includes syntax for associated statements, APIs, or commands.

Results in this section come from these books:

JDBC Developer's Guide and Reference
PL/SQL User's Guide and Reference
SQLJ Developer's Guide and Reference

[ Next book ]

JDBC Developer's Guide and Reference

Oracle REF CURSOR Type Category

[

Previous book

Next book

]

PL/SQL User's Guide and Reference

Cursor Variables

Cursor Variables As Parameters

REF CURSOR - Cursor Variables

[

Previous book

Next book

]

SQLJ Developer's Guide and Reference

Definition of REF CURSOR Stored Procedure and Stored Function

REF CURSOR Types in SQLJ

Support for Oracle REF CURSOR Types

[Back to top]

Troubleshooting Information About 'ref cursor|cursor variable'

This category includes information about debugging, preventing errors or handling them when they occur, frequently asked questions, and relevant error messages.

Results in this section come from these books:

Error Messages
PL/SQL User's Guide and Reference
Pro*COBOL Precompiler Programmer's Guide
SQL*Module for Ada Programmer's Guide

[ Next book ]

Error Messages

PLS-00426 cursor variable OUT parameter 'string' cannot be FETCH'ed or CLOSE'd

PLS-00989 Cursor Variable in record, object, or collection is not supported by this release

PLS-00990 Index Tables of Cursor Variables are disallowed

PLS-00992 Cursor Variables cannot be FETCH'ed from

PLS-00993 Cursor Variables cannot be passed as RPC arguments or results

PLS-00994 Cursor Variables cannot be declared as part of a package

[

Previous book

Next book

]

PL/SQL User's Guide and Reference

Restrictions on Cursor Variables

[

Previous book

Next book

]

Pro*COBOL Precompiler Programmer's Guide

Restrictions on Cursor Variables

[

Previous book

Next book

]

SQL*Module for Ada Programmer's Guide

Restrictions on Cursor Variables

[Back to top]

Index Entries about 'ref cursor|cursor variable'

The index entries show related terms, and identify the most important places where your subject is mentioned.

Index Entries

allocating cursor variables (Pro*COBOL Precompiler Programmer's Guide)

CLOSECURSOR variable (SQL*Plus User's Guide and Reference)

[entry #2] (SQL*Plus User's Guide and Reference)

cursor variables (Pro*COBOL Precompiler Programmer's Guide)

[entry #2] (SQL*Plus User's Guide and Reference)

[entry #3] (PL/SQL User's Guide and Reference)

[entry #4] (Pro*C/C++ Precompiler Programmer's Guide)

[entry #5] (Pro*C/C++ Precompiler Programmer's Guide)

[entry #6] (Application Developer's Guide - Fundamentals)

[entry #7] (Pro*COBOL Precompiler Programmer's Guide)

advantages (Pro*COBOL Precompiler Programmer's Guide)

allocating (Pro*C/C++ Precompiler Programmer's Guide)

[subentry #2] (Pro*COBOL Precompiler Programmer's Guide)

assignment (PL/SQL User's Guide and Reference)

closing (PL/SQL User's Guide and Reference)

[subentry #2] (Pro*COBOL Precompiler Programmer's Guide)

declaring (PL/SQL User's Guide and Reference)

[subentry #2] (Pro*C/C++ Precompiler Programmer's Guide)

[subentry #3] (Pro*COBOL Precompiler Programmer's Guide)

declaring and opening (Application Developer's Guide - Fundamentals)

fetching from (PL/SQL User's Guide and Reference)

[subentry #2] (Pro*COBOL Precompiler Programmer's Guide)

heap memory usage (Pro*COBOL Precompiler Programmer's Guide)

opening (PL/SQL User's Guide and Reference)

anonymous block (Pro*COBOL Precompiler Programmer's Guide)

stored procedure (Pro*COBOL Precompiler Programmer's Guide)

restrictions (PL/SQL User's Guide and Reference)

restrictions on (Pro*C/C++ Precompiler Programmer's Guide)

syntax (PL/SQL User's Guide and Reference)

use of in recursive functions (Pro*C/C++ Precompiler Programmer's Guide)

using to reduce network traffic (PL/SQL User's Guide and Reference)

using with dynamic SQL (PL/SQL User's Guide and Reference)

opening a cursor variable (Pro*COBOL Precompiler Programmer's Guide)

OracleTypes.CURSOR variable (JDBC Developer's Guide and Reference)

REF CURSOR datatype (PL/SQL User's Guide and Reference)

defining (PL/SQL User's Guide and Reference)

REF CURSORs (JDBC Developer's Guide and Reference)

example program (JDBC Developer's Guide and Reference)

materialized as result set objects (JDBC Developer's Guide and Reference)

[Back to top]

Bibliography

The links on this page lead to many different books. This section lists PDF files that you can download and print, if you want to do further reading. This section also identifies the relevant chapters that you can print out, rather than printing the entire book.

PDF File Major Topics to Print

Application Developer's Guide - Fundamentals

Cursor Variables

Application Developer's Guide - XML

Generating XML from ResultSet Objects

Error Messages

JDBC Developer's Guide and Reference

Oracle Type Extensions
Oracle REF CURSOR Type Category
Samples for Oracle Type Extensions

Oracle Call Interface Programmer's Guide

Advanced Bind Operations

PL/SQL User's Guide and Reference

Main Features
Interaction with Oracle
Using Cursor Variables
Declaring Cursor Variables
Controlling Cursor Variables
Using the OPEN-FOR, FETCH, and CLOSE Statements
Language Elements
Cursor Variables

Pro*C/C++ Precompiler Programmer's Guide

Cursor Variables

Pro*COBOL Precompiler Programmer's Guide

Cursor Variables

SQL*Module for Ada Programmer's Guide

Cursor Variables

SQL*Plus User's Guide and Reference

Using REFCURSOR Bind Variables

SQLJ Developer's Guide and Reference

Oracle Type Extensions
Support for Oracle REF CURSOR Types
Advanced Samples
REF CURSOR--RefCursDemo.sqlj