Oracle-L: Oracle Foreign Key Question

From: Leake, Dale G. <MIS!MISPO1!LeakeDG_at_GRAYGEND.ATTMAIL.COM>
Date: Tue, 23 Jan 1996 09:01:00 +0000
Message-Id: <9601231528.AA14432@alice.jcc.com>

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:28:07 CST