Re: Oracle Foreign Key Question

From: Michael A. Schoen <Michael_Schoen_at_WMG.COM>
Date: Tue, 23 Jan 1996 10:29:15 EST
Message-Id: <9601231549.AA21387@alice.jcc.com>

I haven't had any trouble with CASCADE DELETE, but I do have a related question...

How have people implemented other relational integrity constraints, avoiding the mutating table problem?

Does anyone know if Oracle plans to include CASCADE UPDATE, etc. as declarative constraints in future versions?

Thanks,

Michael Schoen
Andersen Consulting

---

Original Text
>From "Leake, Dale G." <MIS!MISPO1!LeakeDG_at_GRAYGEND.ATTMAIL.COM>, on 1/23/96
9:01 AM:
Platform AIX 3.2.5 running on RS6000

     Oracle 7.0.12

Does anyone know if there is a known problem with Foreign Keys that have Cascade Delete option turned on in Oracle release 7.0.12?

I have an application that deletes a parent table and should cascade delete child table entries connected by a foreign key.

I have verified that no orphans exist in the child table, run my application that processes the parent deletes (successfully as far as I know...no abort), and rerun my check program on the child table, but now I show orphans exist.

By the way I also verify that the constraint is enabled both before and after the application and it is.

Thanks in advance for any input.
Regards,
Dale Leake
Graybar Electric Co.
St. Louis MO
314-692-5763
AUUNIX:MIS!MISPO1!LeakeDG_at_graygent.attmail.com Received on Tue Jan 23 1996 - 10:49:32 CST