My understanding is that a stored procedure does an implicit begin/commit when
it executes. Maybe my brain isn't working so well this morning, because I can't
figure out how I would do:
begin;
call stored proc;
call another stored proc;
commit;
It seems that the transaction would be committed after the first call.