begin; call stored proc; call another stored proc; commit; It seems that the transaction would be committed after the first call.
begin; call stored proc; call another stored proc; commit; It seems that the transaction would be committed after the first call.