OPEN Cursor

Description

Causes the SELECT specified when the cursor was declared to be executed.

Syntax

OPEN CursorName ;

Parameter

Description

CursorName

The name of the cursor you want to open

Usage

The USING TransactionObject clause is not allowed with OPEN; the transaction object was specified in the statement that declared the cursor.

NoteError handling It is good practice to test the success/failure code after executing an OPEN Cursor statement.

Examples

Example 1

This statement opens the cursor Emp_curs:

OPEN Emp_curs ;