To avoid mutating trigger/function

From: Arijit Chatterjee <arijitchatterjee123_at_yahoo.co.in>
Date: 21 Jul 2004 21:52:16 -0700
Message-ID: <ea01504d.0407212052.217a292a@posting.google.com>

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 Received on Wed Jul 21 2004 - 23:52:16 CDT