Re: DBMS_OUTPUT
From: David K. McLeod <dmcleod_at_denadm.ms.ch2m.com>
Date: 1996/03/27
Message-ID: <31596631.45015189_at_news.ch2m.com>#1/1
Date: 1996/03/27
Message-ID: <31596631.45015189_at_news.ch2m.com>#1/1
Jay Mehta <jvmehta_at_mra.ffx.mobil.com> wrote:
>One more question regarding dbms_output, I got the following error
>message:
>
>ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes.
>
>What parameters do I need to set to increase buffer size?
>
Jay,
Try this:
set serveroutput on size 1000000
The range is 2000 (which is the default, I believe) and 1000000.
Hope this helps...
| David K. McLeod | dmcleod_at_denadm.ms.ch2m.com | | CH2M Hill - Corp. Computing Svcs. | | | Denver, Colorado | "...days, weeks, months, who knows?" | | ...o&o> ...~o=o\ | -- Eeyore | ==============================================================================Received on Wed Mar 27 1996 - 00:00:00 CET