Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: dbms_output.put_line not printing
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
![]() |
![]() |