Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes

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

From: Nalla Ravi <vvnrk2001_at_yahoo.co.uk>
Date: Sat, 29 Jun 2002 09:38:17 -0800
Message-ID: <F001.0048C1BA.20020629093817@fatcity.com>


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). Received on Sat Jun 29 2002 - 12:38:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US