Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> DBMS_OUTPUT
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