Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Tracing ref_cursors

Tracing ref_cursors

From: Manish <manish.shah_at_emagine-int.com>
Date: 5 Dec 2001 18:59:03 -0800
Message-ID: <18b0424d.0112051859.2a05f067@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US