FOR loop for Cursor
l_new_rel_cur is a SYS_REFCURSOR. Can I use for loop to iterate through the sys ref cursor like this. FOR i IN l_new_rel_cur.FIRST .. l_new_rel_cur.LAST LOOP FETCH l_new_rel_cur INTO rel_id; END LOOP;
...also FIRST and LAST are to do with collections, not cursors.
Hi, For more information, you can take a look on this link below: http://www.psoug.org/reference/ref_cursors.html Cheers