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 -> Trigger problem...

Trigger problem...

From: Sandro Colletti <Sandro.Colletti_at_oiz.stzh.ch>
Date: Wed, 18 Aug 1999 14:41:52 +0200
Message-ID: <7pe9oi$2dc$1@pollux.ip-plus.net>


Hi all..

following problem:

i have a after insert trigger for table xxx which starts a function that = should read records from the same table xxx

this function should (after a insert on xxx) read some records to find = out whats different between the new record and older record

i allways get following message:

ORA-04091: table xxx is mutating, trigger/function may not see it

i know i could execute that function later, but it would be great if i = could do that from the trigger

please answer also to stefan.keller_at_oiz.stzh.ch Received on Wed Aug 18 1999 - 07:41:52 CDT

Original text of this message

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