ON UPDATE CASCADE

From: Raj <ratnam_at_staff.singnet.com.sg>
Date: Tue, 6 Aug 2002 17:27:42 +0800
Message-ID: <aio48f$abj$1@reader02.singnet.com.sg>

Im getting something like

SQL> alter table sample add constraint cj_fk foreign key (name) references customer (name) on delete cascade on update cascade;

 references raaj(name) on delete cascade on update cascade

                                         *

ERROR at line 2:
ORA-01735: invalid ALTER TABLE option

please advice me about how to acheive, on update cascade along with on delete cascade.

Thanks!
Robbie Received on Tue Aug 06 2002 - 04:27:42 CDT