Hi All,

I have written a stored procedure in Netezza, which consists of an Insert statement following Update statement. I am catching all the errors in the exception block. Exception block captures all the errors, but it fails to do rollback. Kindly help me how to use rollback inside an exception block?

Thanks in advance...