Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error while creating trigger

Srikkanth.MMay 27 2010 — edited May 27 2010
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 24 2010
Added on May 27 2010
9 comments
1,032 views