Re: SYS.DBMS_OUTPUT buffer overflow... Limited to 2000 bytes of output.(?)

[Quoted] Everyone posting to this letter seems to have the same idea... But ... does anyone have an idea how to get the d**** thing to flush its' buffer? There doesn't seem to be any PL/SQL equivalent of the C function flush(<file descriptor>). the reason I ask is that if your procedure / function crashes you will NOT see the output.

citton_at_shom.fr (Citton Laurent) wrote:

>Or use dbms_output.enable(500000);
 

>In article <3352ACD6.5A95_at_mail.stil.scitex.com>,
>Slava_Natapov_at_mail.stil.scitex.com says...
>>
>>>I am using
>>>SYS.DBMS_OUTPUT for the first time and am quite surprised to find this
 out.
>>>The buffer is evidently defined not to exceed 2000 bytes and is full.
>>>I will need at least 4 times this much space to complete the prog.
>>>I find it hard to believe that you can only output 2000 bytes in
>>>a PL/SQL procedure. The error is below...
>>
>>
>>2000 is min value (default).
>>buffer size can be set up to 1000,000 bytes :
>>next command within sqlplus :
>>
>>set serveroutput on size 500000
>>
>>For more info see sqlplus help on SET command
>>
>>
>>Slava.
 

>--
>Laurent CITTON (citton_at_shom.fr)
>E.P.S.H.O.M (www.shom.fr)
>13 rue du Chatellier
>BP 426
>29275 BREST cedex
>FRANCE
Received on Thu Apr 17 1997 - 00:00:00 CEST