Re: Mutating tables

Robin Parker (parkerr_at_logica.com) wrote:
: Anybody got any ideas on solving this little problem ??
 

: I've got a table which has in its definition, a number column.
: I want to create a trigger which prevents someone deleting a row from the
: table if the average of this column falls below a certain threshold.
 

: If I do a
 

: select avg(col)
: into av
: from my_table;
 

: within the body of the BEFORE DELETE trigger, I get a message saying the
: table is mutating.
 

: HELP |:-o

Does your BEFORE DELETE trigger have
FOR EACH ROW clause?
If yes, try to remove that clause.

Jozef Received on Thu Jul 13 1995 - 00:00:00 CEST