Re: DBMS_OUTPUT buffering

From: komix Hui <huikomix_at_dt.com.hk>
Date: 1996/10/07
Message-ID: <3259A25F.ACC_at_dt.com.hk>#1/1


Naren Chintala wrote:
>
> "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!
> >
> >Is this the normal way DBMS_OUTPUT behaves?
 

As I know, DBMS_OUTPUT behaves as you have experienced. it will not display message on the screen.
DBMS_OUTPUT is just put messages into buffer for your retrieving later.

You should write extra codes to retrieve messages from buffer to display it on the screen.

Best Regards, Received on Mon Oct 07 1996 - 00:00:00 CEST

Original text of this message