Trigger : Newbie problem

Hi,

How to implement a trigger before delete who updates records of the same table ?
I've tried :

(trigger COMPTE.TBS_DELETECOMPTE before delete)

begin

   update compte set cpt_parent = :old.cpt_parent    where cpt_parent = :old.cpt_code and cpt_annee=:old.cpt_annee; end;

But It doesn't work. (ORA-04091 - ORA04088).

TIA Received on Thu Jan 14 1999 - 04:02:35 CST