ORU-10027: Buffer Overflow When Executing Stored Procedure


This post helps fix the following error in JDBC channel:
com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error processing request in sax parser: Error when executing statement for table/stored proc.
java.sql.SQLException: ORA-20000: ORU-10027: buffer overflow, limit of 1000000 bytes
Check the stored procedure and see if you can remove the DBMS_OUTPUT.PUT_LINE procedures. DBMS_OUTPUT is useful when you are collecting small amounts of debugging information or script/procedure output. If you need to capture more output lines, you use UTL_FILE.

Comments

Popular posts from this blog

OS/DB Migration - CMD. STR, TOC, EXT, R3load, DDLDBS.TPL and more

Fixing Inconsistent Table - Table activation fails due to inconsistency between DD and DB

301 Redirect Using SAP Web Dispatcher