ORA-04098: trigger 'HRMS2.NTS_ADVERTISEMENTS_TRIGGER' is invalid and failed

[kavitha N]

Hi,

I am getting below error after triggering in my table.

ORA-04098: trigger 'HRMS2.NTS_ADVERTISEMENTS_TRIGGER' is invalid and failed re-validation

and the below is the query for triggering i used.

create sequence nts_advertisements_seq start with 1 increment by 1 nomaxvalue;
create trigger nts_advertisements_trigger
delete insert on nts_advertisements
for each row
begin
select nts_advertisements_seq.nextval into :new.id from dual;
end;

thanks in advance.