Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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
update cascade does not exist for 7.3, you can program it if you want.
joe
-- Joseph S. Testa, Oracle Database Administrator, mailto:jtesta_at_scioto.net (home) Vice-President Ohio Oracle Users Group, See the Oracle FAQ at http://www.orafaq.org Try http://web.scioto.net/jtesta that is also the place to find the FREE, drop column script ICQ UIN: 2832230(&oracle, home).Received on Wed Nov 19 1997 - 00:00:00 CST