Re: How to force a flush of dbms_output.put_line

From: flange <flange_at_pt.lu>
Date: 1997/05/31
Message-ID: <01bc6dc3$7c86f180$b7d79ac2@LangeFrancois>#1/1

Hi,

        Instead of writting line to dbms output send then by dbms_pipe.

        From an other session run a small pl-sql block whihc read from dbms_pipe and display the line by dbms_output. execute this program all times.

        REM TO DEBUG.                          Send to dbms_pipe.

                Send to dbms_pipe

        REM displayer

		begin
			read_pipe( time to wait 100000)
			display
		end ;

	to run it all time.


		while cat displayer.sql
		do
			:
		done ¦ sqlplus user/password_at_db

Francois.

                cat

Xuewei Zhou <zhou_at_Glue.umd.edu> wrote in article
<5mk7d6$8qn_at_y.glue.umd.edu>...

> 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
>
Received on Sat May 31 1997 - 00:00:00 CDT