Re: Foreign Key in ORacle 7.3

From: H. John C. Hopkins <john_spam_free_at_hpe.ufl.edu>
Date: 1997/11/20
Message-ID: <6524bj$27e@no-names.nerdc.ufl.edu>#1/1

That would be an UPDATE CASCADE operation. Unfortunately, Oracle does not offer this functionality inherently.

You could write PL/SQL code to handle it. I've seen an update cascade package on govt.us.oracle.com's website (free).

Try there.

Good luck!
-John

Wai B Kam wrote in message <34732c34.0_at_news.ic.sunysb.edu>...
>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
Received on Thu Nov 20 1997 - 00:00:00 CST