Invalid trigger

Hi,

I'm getting an error when trying to insert into a table

ORA-04098: trigger 'DAVE.ADDRESS_ID_TRIG' is invalid and failed re-validation

Not really sure what this means. I had no problem creating the trigger. The trigger is as follows:

CREATE SEQUENCE ADDRESS_SEQ; CREATE OR REPLACE TRIGGER ADDRESS_ID_TRIG BEFORE INSERT
ON ADDRESS
FOR EACH ROW
BEGIN
SELECT ADDRESS_SEQ.NEXTVAL
INTO :NEW.ADDRESS_ID
FROM DUAL; I'm using Oracle8i Enterprise Edition Release 8.1.7.0.1 on Linux Redhat 7, kernel 2.4.2

Any ideas? Many thanks in advance.

Dave Received on Tue Jun 12 2001 - 18:58:05 CDT