MySQL Forums
Forum List  »  Stored Procedures

Re: Capture error messages using DECLARE statements
Posted by: Vivian Fonger
Date: June 27, 2005 11:10AM

Hi everyone,

I am running into the same situation. I would like to either
a) log the error into a log table
b) able to raise the error back to JDBC calling application

It is very important for my stored procedures to bound transactions (i.e. START TRANSACTION, COMMIT, ROLLBACK) due to business logic. It is also very important that user can understand there is an error occurs and what kind of error occurs to cause transaction rollback.



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.