cascade update (ORA-4091)

hi all,

i have a problem with a trigger on a table (before update trigger), the table is build in hierarchies structure , this mean that it had an ID and FATHER_ID columns that conected to each other .
i build a trigger on the table that update the parrent (and i plan it that it will upadte the fathers father (grand father) and so on untill the ROOT)
but oracle shout at me with an error : ORA-4091. i try to move the trigger to outer procedure and got the same problem.

does anybody has an idea how to update the table in cascade way (up to the top) ?

Thanks
 Ofir Received on Mon Jul 27 1998 - 09:14:49 CDT