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!

ORA-04082: NEW or OLD references not allowed in table level triggers

user543623May 31 2012 — edited Jun 1 2012
Hi,

I get this error when i run the below query.

Please advise.

create or replace trigger newEmpTrigger
after update of sal on Emp224
REFERENCING NEW AS NEW OLD AS OLD
begin
insert into Emp224_record
values(SYSDATE , 'Salary Updated', :new.idd );

end;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 29 2012
Added on May 31 2012
5 comments
13,638 views