skip to main content

SAP NetWeaver Newbie

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.

1 comment:

  1. Search Terms: cloud backup, stored procedures db2,
    redo backup, oracle database server

    ReplyDelete

Email Subscription

Get every new post into your inbox by subscribing us.

Want a reason to subscribe?
1. This sitemap might convince you to subscribe.
2. We do not misuse email IDs. We respect privacy.

© 2008 - 2017 sapnwnewbie. All rights reserved.