1 Reply Latest reply on Jan 19, 2012 11:28 AM by 894085

    each procedure have commit statement

      I call five procedure individually, and each procedure have commit statement from .net environment i.e. click event of submitt button call five procedure
      but now i want only one commit statement for all five proceduce if all procedure successfully

      suppose first two procedure successfully execute then third procedure raise some exception, in that case previously execute procedure data successfully comitted, but i want them rollback because all five procedure does not successfully execute.