...

View Full Version : stored proc error handlingh



BubikolRamios
03-31-2013, 09:54 PM
just did some testing, this:



DECLARE CONTINUE HANDLER FOR SQLEXCEPTION
BEGIN
set i_result = -1;
END;

is pointless, coz jou don't get out what caused error.

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);



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum