Re: SYS.DBMS_OUTPUT buffer overflow... Limited to 2000 bytes of output.(?)
From: AMARENDRA B NETTEM <nettama_at_charlie.cns.iit.edu>
Date: 1997/04/19
Message-ID: <01bc4cbc$eebf7a60$86a757c6_at_vanaja>#1/1
Date: 1997/04/19
Message-ID: <01bc4cbc$eebf7a60$86a757c6_at_vanaja>#1/1
Hi Mark
In your executable section
add
DBMS_OUTPUT.ENBALE(1000000);
HOPE THIS HELPS
--
AMARENDRA B NETTEM
ORACLE CONSULTANT
WHITTMAN-HART INC., CHICAGO
(http://www.iit.edu/~nettama)
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 Sat Apr 19 1997 - 00:00:00 CEST