MySQL Forums
Forum List  »  Partitioning

Partitions
Posted by: Ranga Pulavarthi
Date: March 28, 2011 02:38AM

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

Thaks
Ranga

Options: ReplyQuote


Subject
Views
Written By
Posted
Partitions
3169
March 28, 2011 02:38AM
1343
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.