Skip to Content
0
Former Member
Sep 06, 2011 at 08:56 AM

ABAP proxy to Stored procedure on MySQL sync

48 Views

Hi,

I have one question regarding above scenario. Scenario is like this: user will run sync scenario from some ABAP report, which will connect to PI through ABAP proxy, execute some stored procedure on MySQL server, get data back and update some Z-table in SAP.

My concern is beacuse of stored procedure and some weird situations. Stor.procedure selects data and immediately after does update on same data. What I happend in my situation. I ran it for the first time, with debugger, ABAP proxy made call and returned data, but because of compiling and debugging, I lost connection and I LOST DATA, because stored procedure made select and update and I don't have this data anymore. Is there any chance to restart this kind of process? I know this will not happend usually, but want to be sure.

thx

Edited by: Mario Slopar on Sep 6, 2011 10:58 AM