DBMS_OUTPUT info needed [message #37589] |
Thu, 14 February 2002 22:33 |
marco
Messages: 46 Registered: March 2001
|
Member |
|
|
hi all,
I'm using the DBMS_OUTPUT PACKAGE and I wonder if it is possible to put the command "set serveroutput on" inside a stored procedure so that one doesn't have to type it before making the call from sql+?
and is there a way to see the DBMS_OUTPUT.PUT_LINE from TOAD?
Thanks,
Marco
|
|
|
Re: DBMS_OUTPUT info needed [message #37596 is a reply to message #37589] |
Fri, 15 February 2002 03:24 |
pratap kumar tripathy
Messages: 660 Registered: January 2002
|
Senior Member |
|
|
Hi,
The DBMS_OUTPUT package does not contain any mechanism for printing . it implements a first in , first out data structure.
The third party tool like sql*plus have option set serveroutput on and these tool call dbms_output.get_lines to retrieve the data from buffers only when pl/sql block is completed.so it is not possible to echo the output to screen when pl/sql block is executed.
in toad go to database-->dbms output.
cheers
pratap
|
|
|