Need pointers to do stored procedure at receiver side in SAP PI 7.31 !!

[Former Member]

Hi All,

I need to use stored procedure in Proxy to JDBC scenario due to high volume of data.

Currently, I am using standard update/insert command but it is giving deadlock error in PI.

Please let me know step wise details to create new receiver structure using stored procedure in PI ESR.

Also, let me know what all settings need to be done at database side for the same.

Thanks

Neha Verma

[Former Member]

Hi All,

In addition, I would also like to clear that we are updating/inserting into 2 tables together (header/details) in the same database.

So, I would need stored procedure structure accordingly.

Thanks

Neha Verma

[Former Member]

Hello,

>>Currently, I am using standard update/insert command but it is giving deadlock error in PI.

Check my reply in below thread to insert huge data in a xml string format to DB

Thanks

Amit Srivastava

[Former Member]

Hi Neha,

Please have a look at the following links:

They will be helpful for your Scenario.

Thanks &  Regards,

Tejas Bisen