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.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.
java.sql.SQLException: ORA-20000: ORU-10027: buffer overflow, limit of 1000000 bytes