XP is just a number | |
PerlMonks |
Deleting a branch from a tree structureby Stegalex (Chaplain) |
on Apr 22, 2003 at 23:04 UTC ( [id://252392]=perlquestion: print w/replies, xml ) | Need Help?? |
Stegalex has asked for the wisdom of the Perl Monks concerning the following question:
I am pretty sure that this is going to entail the use of recursive subroutine calls, but I just can't get my mind around this problem. I have a self referencing table in Oracle called "CATEGORY". A category can be a sub-category of a sub-category ad nauseum. The problem I have encountered is that Oracle's "ON DELETE CASCADE" referential integrity contstraint doesn't work on self-referencing tables (ORA-2292). So what I need to do is to build a function that will start at a node in the Category tree and delete it and all of its subcategories. Not looking for you to write my code, just looking for a snippet or a reference to a useful pre-existing module. Thanks all. ~~~~~~~~~~~~~~~ I like chicken.
Back to
Seekers of Perl Wisdom
|
|