Re: another ORA-04091 trigger problem

From: Rob Cecil <rcecil_at_my-deja.com>
Date: 2000/07/12
Message-ID: <8kihib$12l$1@nnrp1.deja.com>#1/1

Ok,
Now I know that the error is caused by a foreign key constraint. I failed to mentioned these constraints in my last original post of the table definitions because the fk and pk constraints are defined in separate files. I had a fk constraint defined as

ALTER TABLE KTUSER.ACTION_TRACKER_HISTORY ADD CONSTRAINT ATRACKER_HISTORY_FK_ATRACKER FOREIGN KEY ( ACTION_TRACKER_ID
) REFERENCES KTUSER.ACTION_TRACKER(
ACTION_TRACKER_ID
) ON DELETE CASCADE; Notice this is the table being inserted into by the trigger as

INSERT INTO action_tracker_history VALUES (:OLD.action_tracker_id,
sysdate,
:OLD.responsible_user_id,
:NEW.responsibl_user_id

);

Thanks for your help

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Jul 12 2000 - 00:00:00 CDT