MySQL Forums
Forum List  »  Stored Procedures

Re: Capture error messages using DECLARE statements
Posted by: Peter Schwager
Date: February 13, 2006 03:07AM

The correction of this bug is of high importance! In the meantime I do not use general "Exit handlers" in simple SP. This allows to catch the proper exception within the application.
However if you use nested SP you are definitvely lost! An exception in the inner SP will not be noticed by the application program. You need to implement handlers but than you lose the error code.

Options: ReplyQuote

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.