Help Required on Cross Referencing with Oracle Stored Procedure

[Former Member]

Hi Experts,

I have a requirement which is having the requirements as follow,

Web Application initially sends a request number to SAP ECC to fetch the response details through SAP PI (HTTP to RFC u2013 Synchronous). While fetching the response from SAP ECC system, SAP PI has to invoke a Oracle Stored Procedure based on some parameter from SAP ECC System and then composited data has to send back to Web Application by SAP PI.

Request you to kindly suggest how to achieve the above. JDBC lookup is not much extended to call stored procedure. It would be helpful if it will be a step by step as I am novice to SAP PI.

Regards

Archana

[Shabarish_Nair]

you might very well have to use a BPM.

open a sync/async bridge ->

do a sync call to RFC ->

Do a sync call to DB (use SP here) ->

do a transformation from the response message of RFC and Response of DB (N:1) to for your response to original caller (http)

Close the sync async bridge using the response message