Ron Reidy <rereidy_at_indra.com> wrote in message news:<3C101315.CA15E9EB_at_indra.com>...
> Manish wrote:
> >
> > > You need to invoke the plsql from java, not have the plsql invoke the java, in
> > > this case.
> >
> > I'm not sure I understood your response.
> >
> > My requirement is:
> >
> > I'd like to write a stored proc that takes any ref_cursor and prints
> > out its contents to dbms_output.
> >
> > Since PL/SQL cannot do this, I thought maybe I could pass the
> > ref_cursors to a Java class that can. You say that this is not
> > possible, so it would seem that my requirement cannot be fulfilled.
> >
> > Cheers,
> > Manish
> >
> > Thomas Kyte <tkyte_at_us.oracle.com> wrote in message news:<9unmf302tdo_at_drn.newsguy.com>...
> > > 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
> What do you mean 'print out it's contents'? Do you mean the data, or
> the SQL the ref cursor is a part of?
I mean the data.
Received on Mon Dec 10 2001 - 20:49:44 CST
