Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: dbms_output.put_line not printing

Re: dbms_output.put_line not printing

From: Mark Bole <makbo_at_pacbell.net>
Date: Thu, 19 Feb 2004 02:40:39 GMT
Message-ID: <HmVYb.27507$Ph1.15108@newssvr25.news.prodigy.com>


Pete Finnigan wrote:
> Hi,
>
> [...]else simply change your dbms_output.put_line calls to
> utl_file.put_line calls and set up utl_file and open a file first. You
> can then cat the file in another session and watch it in real time. [...]
> hth
>
> kind regards
>
> Pete

And, in version 9.2, you can also use the "autoflush" option to write data to the buffer and immediately flush the same to the file.

Don't forget to create a directory object first....

--Mark Bole Received on Wed Feb 18 2004 - 20:40:39 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US