Re: Foreign Key in ORacle 7.3

Wai B Kam wrote:
>
> I create a foreign key with ON DELETE CASCADE option. When I delete the parent key, the child key
> does get deleted. But if I try to update the parent key, error comes up saying child key found.
> I thought Oracle will handle that also?? Please Help me. Thank You

Hi,

you could use an before update trigger to updatre the childs:

Update childtable set fk=:new.pk where fk=:old.pk;

-- 
Regards

Matthias Gresz    :-)