Mutating error.
From: Amai Ng <amai_at_pacific.net.sg>
Date: 2000/04/14
Message-ID: <8d7b9a$84d$1_at_newton.pacific.net.sg>#1/1
Date: 2000/04/14
Message-ID: <8d7b9a$84d$1_at_newton.pacific.net.sg>#1/1
Hi,
I'm pretty new at PL/SQL, and is trying to find out how do I avoid this
error:
"table xx is mutating, trigger/function may not see it"
??
I need to update a table A using the values in table B (I used trigger of table B), while using a function to calculate a value using a field in the same table B.....
Thanks in advance for the help.
Cheers,
Amai
Received on Fri Apr 14 2000 - 00:00:00 CEST