Re: DBMS_OUTPUT.PUT_LINE and JDBC

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 22 Jul 2002 20:36:10 -0700
Message-ID: <92eeeff0.0207221936.446d172d_at_posting.google.com>


Ken Koellner <kvk_at_rcn.com> wrote in message news:<3D3716BB.87FD254D_at_rcn.com>...
> I have some Oracle procedures that use DBMS_OUTPUT.PUT_LINE to print
> textual output for the purposes of logging progress on some long
> multi-step updates. I'd like to fire these off from Java/JDBC
> programs. Does anyone know of any way in JDBC to get this messages
> back? I like the Java program to print them to a log file. I need them
> in the Java program as these messages should be interspersed with other
> messages from non-Oracle related tasks the program performs. I spend
> sometime looking at the API Doc for many of the classes/methods in
> java.sql.* and I haven't found anything. Any idea?
>
> -Ken

Check out this code example by Tom Kyte at following post. http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&threadm=ag6q6p02eqk%40drn.newsguy.com&rnum=14&prev=/groups%3Fq%3Dauthor:tkyte%2540oracle.com%26hl%3Den%26lr%3D%26ie%3DUTF-8%26start%3D10%26sa%3DN

Regards
//Rauf Sarwar Received on Tue Jul 23 2002 - 05:36:10 CEST

Original text of this message