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_at_videotron.ca> wrote in message
news:VD9r8.7964$c_.289847_at_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
>
>
Received on Thu Apr 04 2002 - 23:19:53 CST
