Causes the SELECT specified when the cursor was declared to be executed.
OPEN CursorName ;
Parameter |
Description |
---|---|
CursorName |
The name of the cursor you want to open |
The USING TransactionObject clause is not allowed with OPEN; the transaction object was specified in the statement that declared the cursor.
Error handling It is good practice to test the success/failure code after executing an OPEN Cursor statement.
This statement opens the cursor Emp_curs:
OPEN Emp_curs ;