>>>>>What is the correct syntax? TIA
>>>>
>>>>I don't think there is a way.
>>>
>>>Do think that in this case instead of setting ON DELET in foreign key constraint I need to do it in Trigger?
>>
>>Yes, with the trigger you can do this.
>
>Thank you. Do you think it is a step back in using trigger for cascading and updating instead of using foreign key constraint?

Well, using FK constraint is the simplest thing to do, but if it doesn't work the way we need, triggers are the second logical step.