The result set that is associated with a cursor cannot be referenced until the cursor has been opened.
>>-OPEN--cursor-name--+--------------------------------------+->< | .-,--------------. | | V | | '-(--expression----+------------+-+--)-' '-expression-'
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;