Re: Cascading Update Triggers

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Thu, 28 May 1998 01:37:10 GMT
Message-ID: <3571bf24.3092466@192.86.155.100>

A copy of this was sent to mike_andrew_at_usiva.com (if that email address didn't require changing) On Wed, 27 May 1998 13:23:52 GMT, you wrote:

>I am gettting a mutating table error when I try to update the primary key in
>the parent table with enabled after update cascading triggers.Is there a
>standard way to write this trigger, based on one parent and one child??
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading

If you goto http://govt.us.oracle.com/ and follow the links to downloadable utilties, you'll find a cascade update package that generates all of the needed packages/triggers to automatically cascade updates for you.

it supports:

• Tables with multi-part primary keys (primary key(a,c,b))
• Update cascade to many child tables from one parent
• Self-referencing integrity such as that found in the SCOTT.EMP table (mgr->empno)
• Is completely application transparent. The application does not know it is happening
• Versions 7.0 and above of the database.
• Tuned and optimized to fully avoid full table scans on all tables (complete with utility to show you un-indexed
• foreign keys in a schema, Cascading an update to un-indexed foreign keys can be bad).

It has a couple of documented limits as well...  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA  

http://govt.us.oracle.com/ -- downloadable utilities  

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation  

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 Wed May 27 1998 - 20:37:10 CDT