ORA-20000:ORU-10027:buffer overflow, limit 50000 bytes
jtomasicAug 17 2010 — edited Aug 27 2010Hello Ya'll,
We have an in-house written utility to import data to a database table through an user interface on a weekly basis. The import process runs successfully once a week in production, but when I try to run the same process in my personal schema, I receive the following error message (database ver 10.2.0.2; Oracle server - Enterprise Edition):
ORA-20000:ORU-10027:buffer overflow, limit 50000 bytes
ORA-06512:at"SYS.DBMS_OUTPUT', line 32
ORA-06512:at"SYS.DBMS_OUTPUT',line 97
ORA-06512 at"SYS.DBMS_OUTPUT',line 112
ORA-06512:at"PLMACKLIN.STATE_MMS_INTERFACE" line 414
Could any of you tell me why the above errors occur in my schema and not the production database? BTW, my schema is an image of our production database.
What is the solution to fix the above errors?
Any help in resolving this issue would be greatly appreciated.
Thanks much in advance,
jtomasic
--