getting DBMS_OUTPUT from pl/sql procedure calling from java applicatio

[tacomaslc]

Does anyone know how to get to DBMS_OUTPUT.PUT_LINE information that is generated in a PL/SQL stored Procedure which is called from a java application. (Using the Oracle JDBC driver.)

What I would like to do is display the DBMS_OUTPUT information along with the java System.Output.Println information.
THANKS!

 

[SantaMufasa]

get to DBMS_OUTPUT.PUT_LINE information that is generated in a PL/SQL stored Procedure...

Sorry, can't quite make out what this means. What specific "information" are you looking for?

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.

 

[tacomaslc]

It seems that the output from dbms_output statements is "vanishing" when I call the pl/sql stored procedure from a java application. Its probably written to some trace or log file in oracle. But, I would like access to the output from the dbms_output statements to I can display the output the same as you would with java System.Out.Println statements. THANKS!

 

[SantaMufasa]

I'm not sure if I can be helpful in this case...I'm not a Java user. But I do know that when you are outputting from SQL*Plus using DBMS_OUTPUT.PUT_LINE, that if you do not say "SET SERVEROUTPUT ON" prior to the invocation of DBMS_OUTPUT..., then the output disappears into the bit bucket.

Are you wanting the output to go to your display device or do you want the output to go to a flat file?

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.

 

[tacomaslc]

I would like the output to go to "stdout"...the same place that the output from java System.Out.Println goes. THANKS!

 

[sem]

You may get that output by calling DBMS_OUTPUT.GET_LINE

Regards, Dima

http://seminihin.narod.ru