ora-04098

ORA-04098: Simple trigger is invalid. Why?

There is something wrong with this trigger. But what? CREATE TRIGGER MYCOOLTRIGGER AFTER INSERT ON MYCOOLTABLE REFERENCING NEW AS newRow FOR EACH ROW DECLARE BEGIN END MYCOOLTRIGGER; SQL Developer output: Warning: execution completed with warning TRIGGER MYCOOLTRIGGER Compiled. Is there any way to get more info on this Warning? ...

Oracle trigger failed -ORA-04098

I have a table for which i have written a trigger: CREATE OR REPLACE TRIGGER ac01_control_trigg AFTER INSERT ON ac1_control_test FOR EACH ROW DECLARE BEGIN IF :NEW.cur_pgm_name = 'LSN' AND :NEW.nxt_pgm_name ='MD' AND :NEW.file_status='RD' THEN INSERT INTO ac1_control_test (FILE_NAME, FILE_PATH,FILE_STATUS,CUR_P...