Re: DELETE CASCADE PROBLEM!

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 11 May 2001 08:12:45 +0200
Message-ID: <9dfvot$hr9rp$1@ID-62141.news.dfncis.de>

When, do you think, was Oracle 8.0.4 desupported?

Several years ago!

No other choice than to upgrade to Personal Oracle 8.1.6 (win98) or 8.1.7 (NT)

Regards,

Sybrand Bakker, Oracle DBA

"Zed" <zed_at_tecnisainfor.com.br> wrote in message news:01C0D97B.D5DCDC40.zed_at_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 Fri May 11 2001 - 01:12:45 CDT