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

Or, if the output takes more than 100000, you can use UTL_FILE built-in package.

• raman.yagna_at_db.com wrote:
  > set serverout on size 1000000
  > or
  > dbms_output.enable(1000000);
  >
  >
  > Raman
  >
  >
  > ---------------------------------------- Message
  > History ----------------------------------------
  >
  >
  >
  > Please respond to ORACLE-L_at_fatcity.com
  >
  > To: ORACLE-L_at_fatcity.com
  > cc:
  >
  >
  >
  > 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).
  >
  >
  >
  >
  > --
  > Author:
  > INET: raman.yagna_at_db.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).
  

  ---