5 Replies Latest reply on Jan 24, 2013 3:24 PM by 30021986

    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