December 2002
Intermediate to advanced
928 pages
85h 29m
English
OPENcursor_name[(argument[,argument...])];
Opens an explicit cursor. You must open an explicit cursor before you can fetch rows from that cursor. When the cursor is opened, the processing includes the parse, bind, open, and execute phases of SQL statement execution.
When using a cursor FOR loop, the OPEN is implicit in the FOR statement. If you try to open a cursor that is already open, PL/SQL will raise an “ORA-06511: PL/SQL: cursor already open” exception.
Name of the cursor as declared in the declaration section.
Required if the definition of the cursor contains a parameter list.