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

From: Danut Bancea <danut_at_telepages.ca>
Date: Fri, 8 Sep 2000 13:01:54 -0400
Message-Id: <10613.116525@fatcity.com>

Hi ,

You need to run dbms_output.enable(2000000) to increase the size of the buffer. I think that the maximum size is 2m, but I not sure)

Danut,

---

Danut Bancea
Oracle DBA

Tele-Pages Inc.
Phone : (416) 296-9011 Ext. 2271
Fax : (905) 477-7062
E-mail : danut_at_telepages.ca

---

• Original Message ----- From: Maheshwara Rao, L., Teki <teki01_at_mediaone.net> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Friday, September 08, 2000 1:05 AM Subject: Error - ORA-20000:ORU-10027: buffer overflow, limit of 2000 bytes - Please suggest correction

> 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-----
> 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 - 12:01:54 CDT