Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: After Update Trigger

Re: After Update Trigger

From: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 19 Nov 2006 10:48:09 -0800
Message-ID: <1163962101.249130@bubbleator.drizzle.com>


Mikail Dellovich wrote:
> How may I setup a trigger on a table being updated to update another
> table based on the current table being updated with out getting the
> mutating table error. Is there a non row after update trigger for the
> whole table the triggers after all the rows are updated?
>
> Thanks

By posting your database version (the rules are version specific) By posting your trigger code so we can see what you are trying to do By posting the actual error message you are receiving

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Sun Nov 19 2006 - 12:48:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US