Re: Trigger problem...

A copy of this was sent to "Sandro Colletti" <Sandro.Colletti_at_oiz.stzh.ch> (if that email address didn't require changing) On Wed, 18 Aug 1999 14:41:52 +0200, you wrote:

>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

see the url in my signature. there is a HOWTO on mutating tables....

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Wed Aug 18 1999 - 07:52:09 CDT