Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Trigger

Trigger

From: Birgit Kemnitz <B.Kemnitz_at_deutschepost.de>
Date: Wed, 5 Apr 2000 14:53:48 +0200
Message-ID: <8cfd0u$1ia14@ppd00021.deutschepost.de>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US