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

From: Anurag Varma <avoracle_at_gmail.com>
Date: 13 Jun 2005 13:09:54 -0700
Message-ID: <1118693394.642927.5290@o13g2000cwo.googlegroups.com>

Looks like a bug to me. It throws an error when you specify the col1 value
as a number instead of a character (as shown below):

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

1 row deleted.

10G> rollback;

Rollback complete.

10G> delete from tester where col1 = 2;
delete 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:09:54 CDT