Re: How to force a flush of dbms_output.put_line

From: Sergey V. Fedorishin <sfedor01_at_grads.fiu.edu>
Date: 1997/06/16
Message-ID: <5o25p1$2s7@isis.fiu.edu>#1/1

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. Received on Mon Jun 16 1997 - 00:00:00 CDT