How to call the RFC after successful execution of the Stored Procedure

[Former Member]

Hi Everyone,

Kindly provide me the solution for this:

Sender : RFC (system 1)

Receiver : JDBC (system 2)

Receiver : RFC (system 1)

I need to configure 2 receivers, but requirment is that after my stored procedure is executed successfully in receiver system, i need to send some particulars details back to sender system. But, my stored procedure is not having any response. So, how can i handel the call of next RFC after the execution of Stored procedure successfully.

needs your valuable suggesstions.

Thanks

Nutan

[former_member187339 · Accepted solution]

Hi Nutan,

>>But, my stored procedure is not having any response.

Rewrite your SP to retun the required field. Then you can make a RFC <-> JDBC sync interface

else once the SP is triggered call another SP in Database which send request to XI (this is a bit tedius). In this case you have two interface(h async RFC to jdbc and reverse)

Regards

Suraj

[Former Member · Accepted solution]

Hi,

As per the suggesstions,I need to change the SP, but is there any other way to without making any changes in SP.

Regards,

nutan

[former_member187339 · Accepted solution]

Hi,

One of the way can be to write a DB trigger which will get invoked when this SP is executed and inturn give the results to XI.

another one can be to create a new SP which will keep checking the affected records (based on some flag) and provide the result to XI.

Regards

Suraj

[Former Member · Accepted solution]

Hi Everyone,

Thanks for all your valuable inputs. I got the solution without doing any changes in SP. I am just posting the file in an internediate location after the successful execution of SP and then picking that file and sending the response through calling the other Bapi to sender system.

Regards,

Nutan