Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> DBMS_OUTPUT

DBMS_OUTPUT

From: Jaros³aw Palka <jarek_at_kamsoft.com.pl>
Date: 1998/02/05
Message-ID: <34D9A840.5569348A@kamsoft.com.pl>#1/1

I found in Oracle DBMS (release 7.3.2) documentation :

'Note: Messages sent using the DBMS_OUTPUT are not
actually sent until the sending subprogram or trigger completes. There is no mechanism to flush output during the execution of a procedure.'
And this :
'Attention: Output that you create using PUT or PUT_LINE is
buffered in the SGA. The output cannot be retrieved until the PL/SQL program unit from which it was buffered returns to its caller. So, for example, Server Manager or SQL*Plus do not display DBMS_OUTPUT messages until the PL/SQL program completes. In this release, there is no mechanism for flushing the DBMS_OUTPUT buffers within the PL/SQL program.'

In what release of Oracle there is mechanism for flushing that buffers within PL/SQL program ?

-- 
****************************************************
* Jaroslaw Palka <jarek_at_kamsoft.com.pl>            *
* Przedsiebiorstwo Informatyczne KAMSOFT, Katowice *
****************************************************
Received on Thu Feb 05 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US