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



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

Answer / guest

Cause: A trigger (or a user defined plsql function that is
referenced in this statement) attempted to look at (or
modify) a table that was in the middle of being modified by
the statement which fired it.

Action: Rewrite the trigger (or function) so it does not
read that table.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-04084: cannot change NEW values for this trigger type

1 Answers  


QSM-02036: in-list present in mv

1 Answers  


ORA-16600: Failover operation can only be submitted at target database.

1 Answers  


RMAN-06470: DEVICE TYPE is supported only when automatic channels are used

1 Answers  


AMD-00121: dimension #string: analytic workspace hierarchy not specified

1 Answers  






NZE-28823: Number of random bytes to generate is not specified.

1 Answers  


ORA-25276: table specified is not a queue table

1 Answers  


ORA-19731: cannot apply change to unverified plugged-in datafile string

1 Answers  


ORA-15125: ASM file name 'string' contains an invalid template name

1 Answers  


PLS-00752: Table function string is in an inconsistent state.

1 Answers  


EXP-00078: Error exporting metadata for index string. Index creation will be skipped

1 Answers  


Hi guys, I have four tables those are emp,dept,eliminate and uneliminate. i wrote small cursor..when i run, it display one error (ORA-01403 nodata found)... The query is: Declare cursor c1 is select e.ename emp_name from emp e,dept d where e.deptno=d.deptno group by deptno; r1 c1%rowtype; test_emp varchar2(200); begin for r1 in c1 loop begin select eliminate_emp into test_emp from eliminate t,uneliminate ut where t.number=ut.number and t.deptno=e.deptno and rownum<1; end; dbms_output.put_line(r1.emp_name); end loop; end; Thanks...

0 Answers   IBM,


Categories