CODEWITHSUNDEEP
oracle-databasetriggersora-04098
ms1997
ms1997

Reputation: 1

Why the error ORA-04098 is raised?

I try to run the following trigger code on Oracle 11g:

create trigger attempt
  before insert on orde
  for each row
begin
  if(:new.supplierid < 10) or (:new.supplierid > 99) then

    dbms_output.put_line('SUPPLIERID SHOULD BE BETWEEN 11 AND 99');

  end if;
end;

It successfully creates the trigger, but when inserting any values into the table orde, it generates the following error:

ORA-04098: trigger 'GOOGLE.ATTEMPT' is invalid and failed re-validation

Why this error is raised?

Upvotes: 0

Views: 95

Answers (0)

Related Questions