Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Invoque SP win SQL Dynamic

Hi.

I have one scenary with JDBC Receiver that execute an Stored Procedure. I select mode batch and appear the next error:

Delivery of the message to the application using connection JDBC_http://sap.com/xi/XI/System failed, due to: com.sap.aii.af.ra.ms.api.RecoverableException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'INSERTA_COM_LIQDET2' (structure 'Statement_1'): java.sql.SQLException: FATAL ERROR in structure 'Statement_1': Action EXECUTE(WITHRESULT) is not supported in batch mode.

In the help indicate:

Batch processing is not supported for the following statements:

1. SELECT

2. INSERT_UPDATE

3. EXECUTE

4. SQL_QUERY

It's possible to execute stored procedure using SQL Dymanic.

Anyone know how?

Regards,

Julian

Former Member
Not what you were looking for? View more on this topic or Ask a question