Re: ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes

Ravi,

The DBMS_OUTPUT package stores all output from PUT_LINE commands into a buffer, and this error indicates you are overflowing this buffer. The default size is 2000. If you are executing from SQL*Plus you can change the size of the DBMS_OUTPUT buffer using the "SET SERVEROUTPUT ON SIZE n", where "n" is 1000000 or less...

Alternatively, if you are not using SQL*Plus, then you can change the buffer size using "DBMS_OUTPUT.ENABLE(n)", where "n" is the size...

Hope this helps...

-Tim

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Saturday, June 29, 2002 11:38 AM

> Dear All,
>
> When We run simple pl/sql we are getting the follwoing
> error
> ORA-20000: ORU-10027: buffer overflow, limit of 2000
> bytes.
>
> But the fact is it is running fine in another database
> Completely on different server).
>
> I have compared the following thigs please let me know
> if there is anything else to check other than the
> follwoing one's.
>
> 1) DB version is same on both the site i.e 8.1.7.0.0
> 2) source for dbms_output is same both the systems. I
> even checked it from dba_source text and everything is
> equal.
> 3) we don't specify anything in either login.sql or
> glogin.sql.
> 4) pl/sql simple one is running same same one is
> running.
>
> Please let me know if I miss anything else other than
> the above.
>
> Cheers,
> ravi.
>
> __________________________________________________
> Do You Yahoo!?
> Everything you'll ever need on one web page
> from News and Sport to Email and Music Charts
> http://uk.my.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: =?iso-8859-1?q?Nalla=20Ravi?=
> INET: vvnrk2001_at_yahoo.co.uk
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tim Gorman
  INET: Tim_at_SageLogix.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).