Unanswered: Oracle 9i - "ORA-04076: invalid NEW or OLD specification"
I'm trying to create a new trigger on a table and am getting
ORA-04076: invalid NEW or OLD specification
Here is the code:
CREATE OR REPLACE TRIGGER BEN.UNIQUE_PAIR
referencing new as newrow
FOR EACH ROW
check_unique_pair(newrow.A, newrow.B) >= 1
BEGIN raise_application_error(-200000,"Attempt to add duplicate row, soft error, ignore and continue");
The bolded line is the one causing the problem. What am I doing wrong?