I want to add some referential triggered actions to my foreign key constraint as shown:

alter table SALESPERSON add
(
FOREIGN KEY(Store#) references STORE(Store#)
on delete SET NULL
on update CASCADE
);

But doing this gives me the "ORA-00907: missing right parenthesis" error message (which makes no sense!)

However, the script below (which is exactly the same as above except I took out one of the triggered actions) works!

alter table SALESPERSON add
(
FOREIGN KEY(Store#) references STORE(Store#)
on delete SET NULL
);

I don't understand why it's like this. According to the examples in my DB textbook, adding both triggered actions in one statement is perfectly valid. Please help. Thanks.