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

Try naming the Trigger something else...

I believe that Oracle is only reading the first 8 letters and 'trigger' is a reserved word...

Call it My_Trigger for instance...

claus_at_js-edb.dk (Claus Nielsen) wrote:

>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 Mon Jul 10 2000 - 00:00:00 CDT