- Describe any REF CURSOR: Get an XML document containing a description of the cursor's columns, including name, datatype, precision, scale and declaration code for a variable usable with this column.
- Fetch any REF CURSOR to memory: Fetch the rows of the cursor into an ANYDATA instance. Optionally manipulate data for each row after it has been fetched through custom PL/SQL code.
- Copy any REF CURSOR: Fetch the rows of the cursor and copy these to either memory or a table and get a new REF CURSOR opened for this copy. Optionally manipulate data for each row after it has been fetched through custom PL/SQL code. Optionally call custom PL/SQL code either before the new REF CURSOR is opened or after.
Read all about it on Finn's blog here: