Re: Problem with DBMS_OUTPUT
From: Gonzalo Sabando <gsabando_at_jet.es>
Date: Fri, 7 May 1999 17:13:39 +0200
Message-ID: <7gv011$b2u$1_at_lola.ctv.es>
Date: Fri, 7 May 1999 17:13:39 +0200
Message-ID: <7gv011$b2u$1_at_lola.ctv.es>
Hi,
I don't know how to get around that DBMS_OUTPUT limitation, but I can suggest you that if you want to have a log file you should try with the UTL_FILE package functions. So you will be able to write a log file in the server machine.
Rgds,
Gonzalo
Hong escribió en mensaje <7gdr4f$76s$1_at_autumn.news.rcn.net>...
>Guys,
>
>
>I have a problem with DBMS_OUTPUT pkg. I need to write log for a SQL/PLUS
>script, however, the log become so large it exceeds 1M buffer that
DBMS_OUTPUT
>offers, how can I get around this without using extra package? Does
DBMS_OUTPUT
>has a fflush function so that you can flush out buffer when it is full?
>
>Thanks.
>
>Hong
>
Received on Fri May 07 1999 - 17:13:39 CEST