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

Home -> Community -> Usenet -> c.d.o.misc -> Database trigger table issue.

Database trigger table issue.

From: Alan D. Mills <alanmNOSPAM_at_uk.europe.mcd.mot.com>
Date: Mon, 20 Apr 1998 15:32:30 +0100
Message-ID: <6hfmc3$dpn$1@schbbs.mot.com> 





I have a database trigger which fires on update of all records of a specific
table (say TABLEA).  What I actually wish to do is to perform more DML on
the same table within the trigger.



I get error 4091 "Table owner.tablea is mutating".  It seems I cannot
reference tablea from anywhere within the trigger firing from it.



Is there a work around for this?



--


Alan D. Mills



To email remove NOSPAM from address.


Received on Mon Apr 20 1998 - 09:32:30 CDT












Original text of this message













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