stored proc error handlingh
just did some testing, this:
is pointless, coz jou don't get out what caused error.
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION
set i_result = -1;
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);