Hi, am using stored procedures for inserting and deleting data into tables. How to maintain maintain transactions with in SP's calling SP another SP, pls let me know how to do it
SP1 (Parent SP calling from UI code aspx page)
Calling SP2 with in SP1 (data inserting in to a,b,c tables)
Calling SP3 with in SP1 (data inserting in to a,b,c tables)
After completion of execution of SP2 and SP3 deleting data from x,y,z tables...If some error occurs between any of these..complete process to be revoked
March 28, 2011 02:38AM
March 29, 2011 08:20AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.