Re: Regarding "dbms_output" .....

From: rob <rob_at_dsdelft.nl>
Date: Thu, 11 Oct 2001 14:42:01 +0200
Message-ID: <9q442c$25a$1_at_news.tudelft.nl>


> I am trying to use DBMS_OUTPUT statements in my PL/SQL code.
> However, the DBMS_OUTPUT statements do not appear immediately. Rather
> they show on "SQLPLUS" prompt later and at unexpected times. Also
> these statements tend to come in batches together of 15-20 statements.
>
> How can I get a better response from DBMS_OUTPUT? I wish to see the
> result as soon as SQLPLUS executes them.

dbms_output is send to the screen when the whole pl/sql block is finished.

Rob. Received on Thu Oct 11 2001 - 14:42:01 CEST

Original text of this message