Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Oracle 9i ON UPDATE CASCADE
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 - 22:22:16 CST