Re: Tracing ref_cursors

In article <18b0424d.0112051859.2a05f067_at_posting.google.com>, manish.shah_at_emagine-int.com says...
>
>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,

thats correct

>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.
>

the java must call the plsql -- the java can get the ref cursor BACK, it cannot get the ref cursor passed to it.

You need to invoke the plsql from java, not have the plsql invoke the java, in this case.

>Cheers,
>Manish

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp