Hi,
I have a scenario but am not about the approach. I would appreciate it if you could share your ideas.
Scenario: We have a DB from which we are going to take data executing a Stored Procedure created at the DB side. Then we sent the data to R3 using ABAP Proxy
Solution: JDBC Sender is executing the stored procedure. the procedure select's the data, sent it, and flag it. PI takes it and sents it to R3 via proxy.
Problem: The problem here is what will happen if the connection is interrupted WHILE the procedure is executed. So that we dont get the data but the procedure flags the rows in the DB.
Can this happen? If yes how can I avoid it?
Thanks.
Arman