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

"Preferred Customer" <rnorthin_at_metasys.com> wrote:

>I think the max is:
>set serveroutput on size 1000000
>
>> Mark S Reichman <reichmanm_at_rl.af.mil> wrote in article
>> <5iimjm$m5a_at_news.rl.af.mil>...
>> > Alright.... So what magic code do I need to extend, flush, or create a
>> > new buffer. My PL/SQL program works fine except that it is evidently
>> > buffering the ouput before displaying on the screen or to a file. 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...
>> >
>> >
>> >
>> > DECLARE
>> > *
>> > ERROR at line 1:
>> > ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes
>> > ORA-06512: at "SYS.DBMS_OUTPUT", line 100
>> > ORA-06512: at "SYS.DBMS_OUTPUT", line 59
>> > ORA-06512: at line 81
>> >
>> >
>> >
>>

Add a line that says

dbms_output.enable(999999);

1000000 is the maximum limit on the number of bytes that the output buffer can send out.

Good Luck,
Raemil

+----------------------------------------------------------------------+
| |     .-.                    "We're very sorry, Mister Schrodinger,  |
| |    /   \         .-.        but the cat refuses to go in the box." |
| |   /     \       /   \       .-.     .-.     _   _                  |
 +--/-------\-----/-----\-----/---\---/---\---/-\-/-\/\/------------- |
| | /         \   /       \   /     '-'     '-'   ^       Joe P Miller |
| |/           '-'         '-'       raemill_at_gate.net / raemil_at_aol.com |
+----------------------------------------------------------------------+