Re: 10g vs 9i or 8i Trigger Question

Ahh .. Its a bug. BUG # 3571946 : DELETE TRIGGER DOES NOT FIRE WHEN DELETE WITH INDEX SCAN Allegedly fixed in 10.2

A workaround is to either include the col2 .. or specify full hint in delete clause:

10G> delete from TESTER where col1 = '2';

1 row deleted.

10G> rollback;

Rollback complete.

10G> delete /*+ full(tester) */ from TESTER where col1 = '2'; delete /*+ full(tester) */ from TESTER where col1 = '2' *
ERROR at line 1:
ORA-20001: Deletion not allowed-already
interfaced!
ORA-06512: at "AVARMA.TESTER_BEFORE_DELETE", line 6 ORA-04088: error during execution of trigger 'AVARMA.TESTER_BEFORE_DELETE' Anurag Received on Mon Jun 13 2005 - 15:32:01 CDT