Mutating problem
Date: 22 Mar 1995 17:49:56 GMT
Message-ID: <3kpo04$935_at_due.unit.no>
I have two tables A and B.
Table A has a field SUMWGT and STATUS and ARTICLE.
Table B has a field WGT and LINENO and ARTICLE.
I would like an Update/Delete Trigger on table B to
compute the SUM(WGT) for all rows,except the one being updated/deleted
with the given ARTICLE
(key on table A is ARTICLE, key on table B is ARTICLE+LINENO)
and Update the row on table A for this given article with
a new STATUS, which depend on the new sum.
The problem is that I get the Oracle error "Table is Mutating",
even if I make sure that the Where-clause doesn't select
the row that is being updated/deleted (the error does not, of course,
occur when inserting).
Can anybody help me out on this one?
I don't want to call a stored procedure from the client-side to
perform the Update on table A. I would like to handle all this
in triggers.
Bjorn T. Dale
toredale_at_flipper.pvv.unit.no
Received on Wed Mar 22 1995 - 18:49:56 CET