Oracle error on VB (ORA-04091)

[Ultdrake]

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

After a research I find many solution in PL/SQL But i'm working on a VB program, I know the problem is cause by the an update on Primary Key and I try DROP all Constraint and recreate it after the update withoput sucess... I'm a bit lost, can u help me? thanks...

Fred

 

[rohanem]

Hi,
I think you have a trigger or a PL/SQL function that is referenced in this statement, is attempting to modify a table that was in the middle of being modified by the statement which fired it.

What u need to do is,re-write the function/code such that it does not reference the table.

rohan

 

[rohanem]

Dropping constarints here is not a solution