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

>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. Received on Mon Apr 14 1997 - 00:00:00 CEST