1 Reply Latest reply: Jan 19, 2012 5:28 AM by 894085 RSS

    each procedure have commit statement

    906833
      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
      executed.

      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.