DBMS_OUTPUT buffering

Hi all,

I am trying to use the DBMS_OUTPUT package to display status lines on my screen while my PL/SQL program is running. I am using the PUT_LINE procedure in various places throughout the code. I get my output, but only when the program has completed executing, defeating the purpose of a status! It seems like Oracle is buffering my output and not processing the PUT_LINES until the code has completed execution.

Is this the normal way DBMS_OUTPUT behaves? Oracle documentation seems to imply not, that I should be able to output messages as the program proceeds.

Any help would be appreciated.

Michael J. Mangieri
Vitro Corporation
mangieri_at_vitro.com Received on Thu Oct 03 1996 - 00:00:00 CEST