Re: Transactions: how to handle a rollback.

[gustavo bellino]

you can also declare an out parameter
for example

drop procedure if exists EditarMarca/
create procedure EditarMarca(
in id_var int(11),
in newNomMarca char(15),
out res char(8))
begin
DECLARE exit handler for 1062 rollback;
set res:='error';
start transaction;
update marcaProd set nomMarca=newNomMarca where idMarca=id_var;
commit;
set res:='ok';
end/

when you have an error the handler goes out the SP and you have the string 'error' in the out parameter and you will know if it did it ok or not
that SP works



Edited 1 time(s). Last edit at 11/03/2005 06:20PM by gustavo bellino.