Re: Capture error messages using DECLARE statements
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
Subject
Views
Written By
Posted
27191
June 27, 2005 09:45AM
Re: Capture error messages using DECLARE statements
9285
June 27, 2005 11:10AM
9804
June 29, 2005 03:54AM
7161
June 30, 2005 05:45AM
5620
September 23, 2005 03:10AM
6387
June 30, 2005 06:30AM
5624
June 30, 2005 09:26AM
5245
June 30, 2005 02:16PM
5626
November 02, 2005 01:41AM
5728
February 13, 2006 03:07AM
7488
February 13, 2006 03:16AM
5796
February 15, 2006 01:58AM
6404
February 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.