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


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

Original text of this message