flushing DBMS_OUTPUT buffer?

From: Christian Bantzer <bantzerc_at_orca.akctr.noaa.gov>
Date: Thu, 9 Apr 1998 11:22:58 -0700
Message-ID: <Pine.SGI.3.95.980409110400.28945A-100000@orca.akctr.noaa.gov>

Hi,
I'd like to use DBMS_OUTPUT.PUT_LINE to display messages during execution of my pl/SQL block.
It appears that PUT_LINE writes to a buffer, which is only flushed after the block / procedure execution has finished. I'd like to get messages during execution though. Is there a way to flush the buffer explicitely?

Thanks

Christian

Christian Bantzer                                   PSMFC-PacFIN F/AKC
christian_bantzer_at_psmfc.org                         Bldg. 4 Rm. 2066   
phone (206) 526 4057                                7600 SandPoint Wy. NE
fax   (206) 526 4074                                Seattle, WA 98115-0070

Received on Thu Apr 09 1998 - 13:22:58 CDT