Skip navigation links

MySQL Forums :: Stored Procedures :: Capture error messages using DECLARE statements


Advanced Search

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.

Thanks

Vivian

Options: ReplyQuote


Subject Views Written By Posted
Capture error messages using DECLARE statements 17631 Cornelius Sybrandy 06/27/2005 09:45AM
Re: Capture error messages using DECLARE statements 6468 Vivian Fonger 06/27/2005 11:10AM
Re: Capture error messages using DECLARE statements 7303 Roland Bouman 06/29/2005 03:54AM
Re: Capture error messages using DECLARE statements 5363 Roland Bouman 06/30/2005 05:45AM
Re: Capture error messages in phpscript 4214 gamut kumar 09/23/2005 03:10AM
Re: Capture error messages using DECLARE statements 4800 Andrew Gilfrin 06/30/2005 06:30AM
Re: Capture error messages using DECLARE statements 4176 Roland Bouman 06/30/2005 09:26AM
Re: Capture error messages using DECLARE statements 3969 Vivian Fonger 06/30/2005 02:16PM
Re: Capture error messages using DECLARE statements 4217 Pavel 11/02/2005 01:41AM
Re: Capture error messages using DECLARE statements 4274 Peter Schwager 02/13/2006 03:07AM
Re: Capture error messages using DECLARE statements 5162 Roland Bouman 02/13/2006 03:16AM
Re: Capture error messages using DECLARE statements 4338 Peter Schwager 02/15/2006 01:58AM
Re: Capture error messages using DECLARE statements 4533 Roland Bouman 02/15/2006 03: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.