create pro_name(v v_type)
begin
start transaction;
declare v_error int default=0;
declare continue handler for sqlexception set v_error=1;
.....
if v_error =1 then
rollback;
else
commite;
end if;
end
create pro_name(v v_type)
begin
start transaction;
declare v_error int default=0;
declare continue handler for sqlexception set v_error=1;
.....
if v_error =1 then
rollback;
else
commite;
end if;
end