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

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
> >
> >
> >
>
Received on Fri Apr 11 1997 - 00:00:00 CEST