Re: How to force a flush of dbms_output.put_line

Sergey V. Fedorishin wrote:
>
> Wayne Linton (lintonw_at_cadvision.com) wrote:
> : Xuewei Zhou wrote:
> : >
> : > I notice dbms_output.put_line does not print out the lines until my procedure
> : > is finished. I put 100 put_line in my procedure, it doesn't print one by one,
> : > it prints all of them at the end. Is there a way to force it print right after
> : > dbms_output.put_line is called?
> : >
> : > Thanks,
> : >
> : > zhou
 

> : Try writing to a pipe, and have another task running that reads the pipe
> : and displays the message.
>
> It seems there is no way to flush dbms_output. It built this way. But,
> it is not clear yet how to 'display the message': dbms_output.put_line???!
> I was trying to use low level file I/O but couldn't open file via fopen:
> it fires invalid_path on every combination of basename and filename I've
> tryed. Any suggestion would be helpful.
>
> TIA -Sergey.
>
> : Wayne Linton
> : Shell Canada Ltd.

dbms_output.put_line won't print until the procedure is over. About the fopen problem. Are you using utl_file package provided oracle then check the parameter in the setup.
I forgot the exact parameter name but you can find out from the parameter table by using

select name, value
from v$parameter
where name like '%file%'

You need to set that parameter as the path name in the init_ora. The utl_file utility will read/write only from/in that directory.

Vijay Darekar Received on Mon Jun 16 1997 - 00:00:00 CDT