Re: DBMS_OUTPUT buffering

"Michael J. Mangieri" <mangieri_at_vitro.com> wrote:
>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?
YES.
>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