Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Tracing ref_cursors
Hi,
I call a lot of PL/SQL stored procs that return ref_cursors, from a Java application server.
To help me debug, I'd like to write a stored proc that takes any ref_cursor and prints out its contents to dbms_output.
The dba's said it was not possible to do this in PL/SQL, so I wrote a Java class to do it instead -
public class Tracer {
public static void traceResultSet(ResultSet rs);
}
I can't work out how to call this from PL/SQL and pass in a ref_cursor. Any help appreciated.
Cheers,
Manish
Received on Wed Dec 05 2001 - 20:59:03 CST