SYS.DBMS_OUTPUT buffer overflow... Limited to 2000 bytes of output.(?)
From: Mark S Reichman <reichmanm_at_rl.af.mil>
Date: 1997/04/10
[Quoted] Message-ID: <5iimjm$m5a_at_news.rl.af.mil>#1/1
Date: 1997/04/10
[Quoted] Message-ID: <5iimjm$m5a_at_news.rl.af.mil>#1/1
[Quoted] [Quoted] [Quoted] [Quoted] 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 [Quoted] SYS.DBMS_OUTPUT for the first time and am quite surprised to find this out. [Quoted] The buffer is evidently defined not to exceed 2000 bytes and is full. [Quoted] [Quoted] 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 [Quoted] a PL/SQL procedure. The error is below...
DECLARE
*
[Quoted] 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 81Received on Thu Apr 10 1997 - 00:00:00 CEST