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

Home -> Community -> Usenet -> c.d.o.server -> ORA-04098: trigger 'BRANCH_MOVE' is invalid and failed re-validation. Any ideas ?

ORA-04098: trigger 'BRANCH_MOVE' is invalid and failed re-validation. Any ideas ?

From: Robin Coode <robinc_at_systems-team.co.uk>
Date: 10 Jun 1999 08:06:33 GMT
Message-ID: <01beb317$39143d40$ce6410ac@robinc.systems-team.co.uk>


I have created (without any compilation errors) a trigger but when actioned I get a ORA-04098 error.
The manual says to drop or disable the trigger but that doesn't help me. Does anyone know what I am doing wrong.

create or replace trigger branch_move
after
update of association_id on person
for each row
begin
insert into branch_movement

        values (:new.id, :new.association_id, 'NEW', sysdate); end;

Many thanks

Robin Received on Thu Jun 10 1999 - 03:06:33 CDT

Original text of this message

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