DBMS_OUTPUT buffering
From: Michael J. Mangieri <mangieri_at_vitro.com>
Date: 1996/10/03
Message-ID: <3254051B.3D08_at_vitro.com>#1/1
Date: 1996/10/03
Message-ID: <3254051B.3D08_at_vitro.com>#1/1
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