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

From: <raman.yagna_at_db.com>
Date: Fri, 8 Sep 2000 16:28:44 +0800
Message-Id: <10613.116492@fatcity.com>

set serverout on size 1000000
or
dbms_output.enable(1000000);

Raman

Message History ----------------------------------------

From: teki01_at_mediaone.net on 08/09/2000 05:05 GMT

Please respond to ORACLE-L_at_fatcity.com

To: ORACLE-L_at_fatcity.com
cc:
Subject: Error - ORA-20000:ORU-10027: buffer overflow, limit of 2000 bytes - Please suggest correction

Environment : Oracle 8.1.6 : Solaris 2.7

One of my developers is getting the following error whenever he runs a stored procedure. Please suggest how I can correct this error.

ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes
ORA-06512: at "SYS.DBMS_OUTPUT", line 106
ORA-06512: at "SYS.DBMS_OUTPUT", line 65
ORA-06512: at "SAMEER.CPRD_MSG_MERC_P", line 102
ORA-06512: at line 1

Thanks,

Rao

teki01_at_mediaone.net

-----Original Message-----
Wisniewski
Sent: Thursday, September 07, 2000 8:46 AM To: Multiple recipients of list ORACLE-L

This is off-topic but if anyone has experience with Informatica's Powermart ETL tool I'd like to have an off-list discussion about your experiences with it. What kind of sustained rates you were able to achieve doing transformations, hints, tuning tips etc.

Please email me directly at brian_wisniewski_at_yahoo.com if you have experience with this tool and are willing to discuss.

Thanks

Brian

Do You Yahoo!?
Yahoo! Mail - Free email you can access from anywhere! http://mail.yahoo.com/

--
Author: Brian Wisniewski
  INET: brian_wisniewski_at_yahoo.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).

--
Author: Maheshwara Rao, L., Teki
  INET: teki01_at_mediaone.net

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

Received on Fri Sep 08 2000 - 03:28:44 CDT