Re: To avoid mutating trigger/function

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Wed, 21 Jul 2004 22:48:00 -0700
Message-ID: <1090475305.753529@yasure>

Arijit Chatterjee wrote:

> Dear all,
> I have the following table structure
> Name Null? Type
> ----------------------------------------- -------- --------------
> ACCOUNTCODE NOT NULL NUMBER(10)
> NAMEOFACCOUNT VARCHAR2(100)
> ParentCODE NUMBER(10)
>
> ParentCODE is used to create hierarchy/tree of accountcode.
> On update of parentcode, the updated parentcode should not be equal to
> any of the accountcode within the subtree of that account.How to solve
> this problem.
> Regards
> Arijit Chatterjee

You've posted the bare minimum and that is not sufficient to advise you to do anything other than to go to http://asktom.oracle.com and look up "Mutating Trigger".

Daniel Morgan Received on Thu Jul 22 2004 - 00:48:00 CDT