Skip to Content
Former Member
Dec 07, 2006 at 07:44 PM

How to make sure the 2 transactions are executed successfully?


Hi All,

I have a scenario wherein, I do two operations:

1. Cancel an Invoice. And, after it is successfully cancelled,

2. Delete the delivery.

Problem, is even though, the invoice cancellation is successful, the tables at the database level are not updated fast enough, for the delete delivery operation to be successful.

<b>And, I cannot use WAIT or COMMIT statements. Even SUBMIT stmnt is also not allowed.</b>

Can anyone guide me, how to ensure that the deletion of delivery happens successfully?