Trigger errors
637049Jun 16 2009 — edited Jun 18 2009Hi all,
I have this code for trigger and I found this error:
the code:
create or replace TRIGGER SEND_MAIL_TRI AFTER late or absent ON Attendances
FOR EACH ROW
DECLARE
CRE VARCHAR2(2000);
PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
commit;
send_email(:new.user_name,:new.user_id,:new.email_address);
END;
and the error:
ORA-04072: invalid trigger type
I do not know the type for late and absent?? so I need your help..
Thanks,