| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Error - ORA-20000:ORU-10027: buffer overflow, limit of 2000 bytes - Please suggest correction
Increase the size of the serveroutput. Try this:
set serveroutput on size #####
(valid range: 2000 to 1000000)
HTP.
Gunawan Yuwono
Oracle DBA
Kansas City, MO
>--- Original Message ---
>From: "Maheshwara Rao, L., Teki" <teki01_at_mediaone.net>
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Date: 9/8/00 5:05:30 AM
>
>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
>also send the HELP command for other information (like subscribing).
>
>
 |
 |