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

reichmanm_at_rl.af.mil (Mark S Reichman) wrote:

> 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...

Try:

set serveroutput on size 100000

Al Lawson
Interactive Group, Inc.
www.interactive-group.com
lawsona_at_interactive-group.com Received on Thu Apr 10 1997 - 00:00:00 CEST