just did some testing, this:
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION
set i_result = -1;
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);