Nalla Ravi£¬ÄúºÃ£¡ hi, SQL>set serveroutput on size 20000000 and retry.
Good luck! chaos [EMAIL PROTECTED] zhu chao DBA of Eachnet.com 86-021-32174588-667 ÔÚ 2002-06-29 09:38:00 You wrote: >Dear All, > >When We run simple pl/sql we are getting the follwoing >error >ORA-20000: ORU-10027: buffer overflow, limit of 2000 >bytes. > >But the fact is it is running fine in another database >Completely on different server). > >I have compared the following thigs please let me know >if there is anything else to check other than the >follwoing one's. > >1) DB version is same on both the site i.e 8.1.7.0.0 >2) source for dbms_output is same both the systems. I >even checked it from dba_source text and everything is >equal. >3) we don't specify anything in either login.sql or >glogin.sql. >4) pl/sql simple one is running same same one is >running. > >Please let me know if I miss anything else other than >the above. > >Cheers, >ravi. > >__________________________________________________ >Do You Yahoo!? >Everything you'll ever need on one web page >from News and Sport to Email and Music Charts >http://uk.my.yahoo.com >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: =?iso-8859-1?q?Nalla=20Ravi?= > INET: [EMAIL PROTECTED] > >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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: chaos INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).