Generally speaking you defer the actual update to an after_update trigger.
In a before_update trigger you populate one or more pl/sql tables that
contain the rows you want to update. You loop through these pl/sql tables
in the after_update trigger.
--
Terry Dykstra [TeamPS]
Canadian Forest Oil Ltd.
mike_andrew_at_usiva.com wrote in message <6kh458$3th$1_at_nnrp1.dejanews.com>...
>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
Received on Wed May 27 1998 - 13:52:40 CDT
