Skip to Content

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

Multiple calls using a stored procedure - JDBC adapter

Hi,

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?

Thanks,

Leanne

Former Member
Former Member replied

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.

<StatementName>

<storedProcedureName action=” EXECUTE”>

<table>realStoredProcedureeName</table>

<param1 [isInput=”true”] [isOutput=true] type=SQLDatatype>val1</param1>

</storedProcedureName >

</StatementName>

Thanks

Satish

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question