Oracle error on trigger

[Guest_imported]

i create a trigger on a table to execute if inserting or updating it populates 4 fields one is the sysdate and the logged in user. It compiles ok but once it executes it produces a error

ORA-04098: trigger trigger_name is invalid and failed re-validation.

 

[karluk]

This error is supposed to mean that the trigger is invalid. That's most likely the problem even though you say it comiled ok. You can verify this by executing the query

select owner, object_name, object_type, status
from dba_objects
where object_name = 'TRIGGER_NAME';

If the trigger is indeed invalid you will have to correct the errors or drop the trigger to allow inserts and updates.