Opening a cursor v16

Before you can use a cursor to retrieve rows, you must open it using the OPEN statement.

OPEN <name>;

name is the identifier of a cursor that was previously declared in the declaration section of the SPL program. Don't execute the OPEN statement on a cursor that is already open.

This example shows an OPEN statement with its corresponding cursor declaration:

CREATE OR REPLACE PROCEDURE cursor_example
IS
    CURSOR emp_cur_3 IS SELECT empno, ename FROM emp WHERE deptno = 10
        ORDER BY empno;
BEGIN
    OPEN emp_cur_3;
        ...
END;