Re: Exit Handler for SQLEexception

[Peter Brawley]

1 Why the cursor for the deletions, why not just

delete a,b
from a join b on ...

2 Rollback is possible only in a transaction, but your sproc doesn't define one, it seems to me you need something like ...

create procedure ...
begin
  declare `_rollback` bool default 0;
  declare continue handler for sqlexception set `_rollback`=1;
  start transaction;
    delete ...;
    insert ...;
  if `_rollback` then
    rollback;
  else
    commit;
  end if;
end;