Re: Cascade Update?

A generic Cascade Update procedure is available in the "Oracle Administration Knowledge Base". The article and DDL are rather lengthy, otherwise I would post it. You can download a 15-day trial copy of the product from http://www.revealnet.com

Bestg wishes,

Cam White
RevealNet, Inc.

In article <3586E7EF.3E51DFF0_at_videotron.ca>,   "René Guitar" <rene.guitar_at_videotron.ca> wrote:
>
> Hello everybody!
>
> Since i've got a new job and get introduce to Oracle, my boss now want
> me to "think" of a little problem for updating records in a new database
> we will implement.
>
> The problem is when you have a parent table with childs and you want to
> update a primary key record on a cascade base, Oracle will not let you
> modify child table because you have "mutate" the parent table.
>
> Parent_Table
> (Name varchar2(20), -Primary key
> ...other records...)
>
> Child_Table
> (Name varchar2(20), -Link to Name in the Parent_table
> ...other records...)
>
> In this little example, i cannot go into the Parent_Table, do an Update
> on the Name record and then go down and change the same record in the
> Child_Table.
>
> So, before going deeper into this problem i want to know if anybody has
> face this situation and if you can provide me some useful information
> (Web Site, book, package, ideas, etc.) that can help me solve this
> situation.
>
> Thanx in advance!
>
> René
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed Jun 17 1998 - 00:00:00 CDT