Path: news.easynews.com!easynews!news-out.visi.com!hermes.visi.com!nnxp1.twtelecom.net!news-east.rr.com!cyclone.kc.rr.com!news.kc.rr.com!news-west.rr.com!cyclone1.we.ipsvc.net!cyclone3.we.ipsvc.net!typhoon1.we.ipsvc.net.POSTED!not-for-mail
From: "Alex Ivascu" <alexdivascu@yahoo.com>
Newsgroups: comp.databases.oracle.misc
References: <VD9r8.7964$c_.289847@wagner.videotron.net>
Subject: Re: Oracle 9i  ON UPDATE CASCADE
Lines: 35
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <Ztar8.13634$071.2874758@typhoon1.we.ipsvc.net>
Date: Fri, 05 Apr 2002 05:19:53 GMT
NNTP-Posting-Host: 24.126.92.36
X-Complaints-To: abuse@attbi.com
X-Trace: typhoon1.we.ipsvc.net 1017983993 24.126.92.36 (Thu, 04 Apr 2002 21:19:53 PST)
NNTP-Posting-Date: Thu, 04 Apr 2002 21:19:53 PST
Organization: AT&T Broadband
Xref: easynews comp.databases.oracle.misc:79699
X-Received-Date: Thu, 04 Apr 2002 22:20:46 MST (news.easynews.com)

Oracle doesn't let you do that.  Don't get Oracle confused with SQL
Server.... [ I guess there is a benefit  for using SQL ] :o)

Alex Ivascu
DBA


"Claude Gagnon" <claudegagnon@videotron.ca> wrote in message
news:VD9r8.7964$c_.289847@wagner.videotron.net...
> Hi,
>
> I want to know if Oracle 9i supports the command ON UPDATE CASCADE.
>
> I have the following constraints and I get an error:
>
> CONSTRAINTS fk_PosteSecond_PostePrim FOREIGN KEY (noP) REFERENCES
PostePrim
> (noP) ON UPDATE CASCADE)
>
> *
> ERROR at line 5:
> ORA-00905: missing keyword
>
>
>
> If I utilize ON DELETE CASCADE, I didn't get any error.
>
>
> Thanks,
>
> Claude
>
>