Hi, I'm getting the above error when I run a transaction. I've traced the error to the below queries. So, it seems that if I raise an error before the following queries run, then the rollback succeeds without any problem. However, if I raise an error after the first 'ALTER TRIGGER...' statement then I get the above error (ORA-01086) and the rollback cannot complete. Obviously the alter trigger (or execute immediate?) statement is preventing Oracle from being able to do a rollback.
So, my question is, what's going on here exactly, and how can I fix it?
EXECUTE IMMEDIATE 'ALTER TRIGGER ctc_table_trig DISABLE';
DELETE FROM CTC_Table;
EXECUTE IMMEDIATE 'ALTER TRIGGER ctc_table_trig ENABLE';