Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

stupid ora-04092 error message

567757Feb 5 2009 — edited Aug 13 2009
I am using Oracle 11g as sever, client from 10g, and ODP.NET 10g to connect from .Net application on IIS.
Since we moved to 11g server we get the following error message on various locations:
ORA-04092: cannot COMMIT in a trigger
Oracle Data Provider for .NET
we get this for procedure calls, procedures with select statements on tables without any trigger.
First the number of error messages was few but now the site sipmply does not works.
we get this for almost every statement randomly.
I suppose that there are some system triggers with problems.
The same configuration is working perfect on other 4 Oracle servers.
What can I do? URGENT HELP NEEDED!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 10 2009
Added on Feb 5 2009
18 comments
2,784 views