Re: Delete Cascade ????

In article 2plq3iINNagu_at_umbc7.umbc.edu, thurston_at_umbc.edu (Mr. Robert Thurston) writes:
>We have a situation in ORACLE in which we are trying, through the
>use of triggers, to do an UPDATE to a parent table cascading to its
>children. Our children tables reference a parent table's unique
>field, though not the primary key. No matter how we write the
>trigger, procedure, etc., we keep getting the MUTATING table error,
>even though we do nothing to that table that the trigger was fired
>upon, only the children.
>
>Is there any way to keep our Referential Integrity (DELETE CASCADE)
>through the table definition, and be able to force some kind of UPDATE
>CASCADE, without having to control all our referential integrity
>through triggers?

Not according to Oracle, they have a fax you can request that outlines how to EMULATE a cascading update by demolishing the other RI stuff they finally gave us!!

C'est la guerre!

---
<<MFF>>


-------------------------------------

"Twenty-Five years ago it meant something to be Crazy!"

			- Charles Manson