Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Trigger
Hello,
I need some help for creating triggers.
I always get the mistake ''ORA-04082: NEW or OLD references not allowed in
table level triggers"
the trigger description is
create or replace trigger protokoll
before delete or insert or update on kostenstelle
declare
statement varchar2(30);
begin
if deleting then statement:='delete';
end if;
if inserting then statement:='insert';
end if;
if updating then statement:='update';
end if;
insert into protokoll2 values (:new.kost,statement,sysdate);
end;
/
show errors
Thanks for helping me,
Birgit
Received on Wed Apr 05 2000 - 07:53:48 CDT
![]() |
![]() |