Error - ORA-20000:ORU-10027: buffer overflow, limit of 2000 bytes - Please suggest correction

From: Maheshwara Rao, L., Teki <teki01_at_mediaone.net>
Date: Fri, 8 Sep 2000 00:01:22 -0400
Message-Id: <10612.116481@fatcity.com>

Hi

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-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Brian Wisniewski
Sent: Thursday, September 07, 2000 8:46 AM To: Multiple recipients of list ORACLE-L Subject: Loading warehouse with Informatica

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).

Received on Thu Sep 07 2000 - 23:01:22 CDT