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

>From metalink:

 "There is an exception to this restriction; For single row INSERTs, constraining tables are mutating for AFTER row triggers, but not for BEFORE row triggers. INSERT statements that involve more than 1 row are not considered single row inserts."

"INSERT INTO <table_name> SELECT ..." are not considered single row inserts, even if they only result in 1 row being inserted. "

Cheers.

Carlos. Received on Wed Jul 27 2005 - 04:14:37 CDT