-
ORA-04082: NEW or OLD references not allowed in table level triggers
hi ,
I am getting the following error i am creating the below trigger
create or replace trigger tr_cdc
*
ERROR at line 1:
ORA-04082: NEW or OLD references not allowed in table level triggers
please help.
thanks
create or replace trigger tr_cdc
after insert on cdcsample for each row
begin
insert into cdcsample@dev(a1,a2,a3,a4) values(:new.a1,:new.a2,:new.a3,:new.a4);
end trigger;
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|