Re: ON UPDATE CASCADE

"Raj" <ratnam_at_staff.singnet.com.sg> wrote in message news:aio490$abk$1_at_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
>
>

1 Check the syntax in your sql reference manual. 2 Note on update cascade doesn't exist
You need to implement this by creating triggers. www.asktom.com should have a generic package to generate those triggers based on appropiate constraints.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address