I forgot to mention that one of the benefits of having all the code in the database is transaction control - if anything fails, you can rollback, even...

ALZDBA - Thanks; I realize it's an old thread, but it's still topical (it was high on Google's matches for my keyword search). I get a lot of good...

Ian Scarlett, I think you misunderstand my post. If you don't want a parent to be accidentally deleted, then by all means don't enable cascade delete. I certainly...

I disagree with SSCrazy. Cascade delete in no way violates referential integrity. On the contrary, it is an integral, and indispensable, part of the RI concept, the point...