| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Cascade update within trigger
A copy of this was sent to Richard Fairbairn <r.fairbairn_at_zetnet.co.uk>
(if that email address didn't require changing)
On Wed, 2 Sep 1998 22:08:45 +0100, you wrote:
>I wish to update primary key column in my table. Is it possible to
>use a trigger to update foreign key column values to reflect this
>change? I've tried, but get an error stating that what I am
>attempting is not allowed. However, I'm led to believe it can be
>achieved somehow. Please help!
>
>Best wishes
>
>R.
>
See http://govt.us.oracle.com/govt/owassi/docs/utility/update_cascade.html
there is a package i wrote there that does update cascade in v7/v8 quite easily -- it generates all of the code you need to cascade the update from a parent to all children and their children and so on.
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA
--
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Thu Sep 03 1998 - 08:47:44 CDT
 |
 |