receiver JDBC HANA Stored Procedure

[Former Member]

Hello,

in my SOAP to JDBC scenario to HANA, I need to call a Stored Procedure as CALL "MyStoredProcedure" ('par1','par2','par3', OUTPUT_TAB => ?).

I use action=EXECUTE, attribute isInput=true for par1, par2 and par3.

Does anybody know how to handle the OUTPUT_TAB parameter, where the result of the Stored Procedure is reversed?

The attribute isOutput=true returns the exception "com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: Internal JDBC error: output parameter at index 4 was not expected."

Thanks to all,

Massimo

[Former Member · Accepted solution]

Solved by removing the output parameter from the stored procedure (which runs a basic Select without reversing the result into any output).