regarding on delete set null ....

[muralik]

Hi all,

I want to refer to a foreign key in a table and set null on delete and on update cascade it...my commands were as follows..

create table Institute(
name varchar(20) not null,
locat_id integer not null,
institute_id integer not null,
primary key(institute_id),
foreign key(locat_id) references Location(location_id)
on delete set null on update cascade,
unique(name)
);

I get the error message as follows

error at line 7: right paranthesis missing....


What is my mistake ...please let me know....

thank you,
regards,
Murali.

[debasisdas]

on update cascade doesnt exist in oracle till the current version.