Re: Regarding "dbms_output" .....
From: Frank van Bortel <fbortel_at_home.nl>
Date: Thu, 11 Oct 2001 20:20:43 +0200
Message-ID: <3BC5E2FB.4AAC5D50_at_home.nl>
Date: Thu, 11 Oct 2001 20:20:43 +0200
Message-ID: <3BC5E2FB.4AAC5D50_at_home.nl>
Aditya wrote:
>
> Hi!
> 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.
>
> Thanks in advance.
> -Aditya
use dbms_pipe instead
-- Gtrz, Frank van BortelReceived on Thu Oct 11 2001 - 20:20:43 CEST