DELETE CASCADE PROBLEM!

From: Zed <zed_at_tecnisainfor.com.br>
Date: Thu, 10 May 2001 21:07:14 +0000 (UTC)
Message-ID: <01C0D97B.D5DCDC40.zed@tecnisainfor.com.br>

Hi Folks!

I have a Personal Oracle 8.0.4 version installed on W95, with a 500MB database. In some tables I have created some foreign keys with CASCADE deletion rule.

But it is not working!!! I can delete the parent records with no error messages about the child records!!! The child records are not being deleted!!!

I have already verified the USER_CONSTRAINTS view. The constraints are enabled, but seems like they aren't.

Is this some known bug? Can anyone help me? I'm kinda scared! I've never imagined that I would have to face a problem like this, working with Oracle.

TIA, ZED
zed_at_tecnisainfor.com.br
(+5531)3262-0696

-- 
Posted from 200-184-152-4.intelignet.com.br [200.184.152.4] 
via Mailgate.ORG Server - http://www.Mailgate.ORG

Received on Thu May 10 2001 - 16:07:14 CDT