Limitations of a normal cursors are —
1) A PL/SQL program cannot pass a cursor as a parameter to another program.
2) A PL/SQL program can only open the cursor and process the information within the program itself. 965 more words
Tags » Ref Cursor
Suppose you want to run a SQL*Plus script from a DOS batch file. The SQL*Plus script does not contain an exit-statement. Yet, you want SQL*Plus to return control to the DOS batch script so you can do some other stuff as well, and you certainly don’t want to type “exit” every time. 110 more words
My web application accesses the database using packages. These packages contain procedures that return refcursors. To test these packages, I searched for a way to easily call the procedures and make the resultset visible. 102 more words