5 Replies Latest reply: Jan 24, 2013 9:24 AM by 945927 RSS

    How to roll back when procedure fails

      Hi All,

      In my process using procedures i am droping the temp tables and creating temp tables ,if any procedures fails how should roll back all the process

      Procedure1(droping tables)----->procedure2(creating table1)--------->procedure3(creating table2)------->procedure4(Validaating accounts in table2 and creating seperate table)

      Any suggestion please

      Thanks in Advance