Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
Thread: stored proc error handlingh
03-31-2013, 09:54 PM #1
- Join Date
- Dec 2005
- Thanked 79 Times in 79 Posts
stored proc error handlingh
just did some testing, this:
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN set i_result = -1; END;
Without that you can get the nature of error (in my case which part of sql caused error) in application part (call for stored proc)
I'm thinking to remove all "FOR SQLEXCEPTION" from my stored procs.
Any comment ?
BTW: how to do something like that (if possible at all):
select message from (SHOW WARNINGS);