Last post May 15, 2013 11:08 AM by pravesh.dobhal
May 10, 2013 09:00 AM|pravesh.dobhal|LINK
Error starting at line 7 in command:
insert into int_member(SAPPLICATIONNO,IMEMBERID,SFIRSTNAME,SMIDDLENAME,SLASTNAME,DTDOB,IGENDERID,IMARITALSTATUSID)
SQL Error: ORA-04091: table MDE_UAT.INT_MEMBER is mutating, trigger/function may not see it
ORA-06512: at "MDE_UAT.TR_MOVEMEMBER", line 4
ORA-04088: error during execution of trigger 'MDE_UAT.TR_MOVEMEMBER'
04091. 00000 - "table %s.%s is mutating, trigger/function may not see it"
*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.
May 10, 2013 01:28 PM|sameer_khanjit|LINK
remove below line from trigger will start working
SELECT COUNT(SAPPLICATIONNO) into rowcnt FROM INT_MEMBER WHERE SAPPLICATIONNO = :new.SAPPLICATIONNO and IMEMBERID = :new.IMEMBERID;
May 13, 2013 07:01 AM|Ajay2707|LINK
The error is because of the DML operation on the same table that is having trigger on it. you can use autonomous transaction in the trigger
please check this.
May 15, 2013 11:08 AM|pravesh.dobhal|LINK
Can you please write some sample code for the same