Fail Trigger [after trigger], MACE

failtrigger2.sql

create table mark (sid number(5) primary key, m1 number(3), m2 number(3), m3 number(3));

create table fail (sid number(5) primary key, m1 number(3), m2 number(3), m3 number(3));

create or replace trigger failtrigger
after insert on mark
for each row
declare
v_total number(3);
begin
v_total := :new.m1 + :new.m2 + :new.m3;
if (v_total < 120) then
	insert into fail values(:new.sid, :new.m1, :new.m2, :new.m3);
end if;
end;
/

insert into mark values(1, 50, 50, 50);

insert into mark values(2, 39, 39, 39);