ORA-04098: trigger name is invalid and failed re-validation

I am unable to use any kind of trigger I make. Not that I have ever succeded at getting any trigger to work, as I am new at this. But I have created the following trigger - just as an example:

CREATE TRIGGER TRIGGER1
BEFORE INSERT
ON TABLE1
FOR EACH ROW
BEGIN
  NEW.ID := 3;
END; The real trigger will eventually call a sequence which will return a uniqe number. But even with this simple trigger, every attempt at inserting a record in my table, results in the following error:

ORA-04098: trigger name is invalid and failed re-validation

The Oracle Documentation gives this explanation:

Cause: A trigger was attempted to be retrieved for execution and was found to be invalid. This also means that compilation/authorization failed for the trigger.

Action: The options are to resolve the compilation/authorization errors, disable the trigger, or drop the trigger.

Unfortunately I can't figure where to go from here? What should I do? Any solutions/suggestions are welcome! Thanks.

Regards, Claus Nielsen Received on Tue Jul 04 2000 - 00:00:00 CDT