Error while creating trigger
Hai All
I have table called Daily_attendance
I need to track the changes made in the table..
I have written a trigger
create or replace trigger dail_attendance
after delete or insert or update on Daiyl_attendance
for each row
begin
insert into audit_dail_att_table(user_name,timestamp,emplcode,old_timein,new_timein,old_timeout,new_timeout,old_attend_date,old_attn_status,old_deptcode)values
(user,sysdate,:old.emplcode,:old.timein,:new.timein,:old.timeout,:new.timeout,:old.attend_Date,:old.attn_status,:old.deptcode);
end;
/
show err;
And i got the error
Warning: Trigger created with compilation errors.
Errors for TRIGGER DAIL_ATTENDANCE
Thanks In Advance
Srikkanth.M