Multiple calls using a stored procedure - JDBC adapter
Scenario - RFC internal table to JDBC stored procedure
The stored procedure accepts parameters. I am able to send one of the records from the internal table to the stored procedure.
Is is possible to send multiple calls to the stored procedure or to pass the whole table to the stored procedure?
You can create multiple STATEMENT rows based on your requirement. This will call your SP that many number of times.
STATEMENT tag will occur for every insertion that you want to happen.
<storedProcedureName action= EXECUTE>
<param1 [isInput=true] [isOutput=true] type=SQLDatatype>val1</param1>