MySQL Forums
Forum List  »  Stored Procedures

Re: Need help in exception handling with transaction in SP
Posted by: Peter Brawley
Date: June 10, 2017 07:49PM

On inspection the logic looks about right: the Exit handler grabs error info, rolls back the transaction, and updates the exception log. You might want to add Signal/Resignal code to the Exit Handler.

If it's not working as desired, can you post a small script that reproduces the problem ?

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Need help in exception handling with transaction in SP
11
June 10, 2017 07:49PM


Sorry, only registered users may post in this forum.

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.