Re: Oracle 9i ON UPDATE CASCADE

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 05 Apr 2002 06:48:51 +0200
Message-ID: <e3bqaugj72oi95loni0m3fv9gdibfcsnsv@4ax.com>

On Thu, 4 Apr 2002 23:22:16 -0500, "Claude Gagnon" <claudegagnon_at_videotron.ca> wrote:

>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
>

A simple check in the Oracle Sql reference manual would have provided the immediate answer: there is NO on update cascade, you need to develop some triggers.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Apr 04 2002 - 22:48:51 CST