Path: news.easynews.com!easynews!hub1.nntpserver.com!news.maxwell.syr.edu!sunqbc.risq.qc.ca!wesley.videotron.net!wagner.videotron.net.POSTED!not-for-mail From: "Claude Gagnon" Newsgroups: comp.databases.oracle.misc Subject: Oracle 9i ON UPDATE CASCADE Lines: 23 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: Date: Thu, 4 Apr 2002 23:22:16 -0500 NNTP-Posting-Host: 66.130.189.173 X-Complaints-To: abuse@videotron.ca X-Trace: wagner.videotron.net 1017980533 66.130.189.173 (Thu, 04 Apr 2002 23:22:13 EST) NNTP-Posting-Date: Thu, 04 Apr 2002 23:22:13 EST Xref: easynews comp.databases.oracle.misc:79693 X-Received-Date: Thu, 04 Apr 2002 21:19:58 MST (news.easynews.com) 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