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

[Quoted] Or use dbms_output.enable(500000);

[Quoted] 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.
 

-- 
[Quoted] 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