I'm using DBMS_OUTPUT in a stored procedure that print a key value
after doing some computations and an insert. When I run this
procedure from SQLPlus, I get no output until the stored proc is
finished. I then get pummelled with a few hundred lines of output.
The stored proc takes about 15 minutes to execute, therefore I can only
assume that the output is being buffered somehow. Does anyone know if
this is the case, and if there is a way to turn it off? I want
to monitor the progress during runtime, and currently the output
is of little use.
--
~~~~~~~~~~~~~~~~~~~~~~~~~
jennings_at_dca.net
Received on Mon Mar 03 1997 - 00:00:00 CST
