MySQL Forums
Forum List  »  Stored Procedures

Advanced Search
New Topic

how to implement rollback if the stored procedure fails after executing few statements
Posted by: vishal bansala
Date: February 17, 2012 09:16AM

Hi all,

I am a new learner of mysql....i want to know that how atomocity can be achieved for an stored procedure....... the procedure which i am trying to write is simple and have few sql statement

the main concern is how can i rollback those statements which have executed before my stored procedure fails......

Please tell me the complete syntax as i am new to mysql.

thanks

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
how to implement rollback if the stored procedure fails after executing few statements
2649
vishal bansala
February 17, 2012 09:16AM
Re: how to implement rollback if the stored procedure fails after executing few statements
1116
irek kordirko
February 17, 2012 11:46AM
Re: how to implement rollback if the stored procedure fails after executing few statements
1175
Rick James
February 26, 2012 12:11AM


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.