Problem accessing db through ASP.NET application

From: makthar (makthar_at_discussions.microsoft.com)
Date: 07/13/04 

Date: Tue, 13 Jul 2004 08:36:01 -0700

We have an asp.NET application previously running fine for many months. The application connects to an Oracle 9.01 database server. Yesterday, with no apparent changes to either the asp.NET application server, or the Oracle database server, the below error occurs when a user attempts to log in to the application. The Oracle DBA states there are no triggers set up except Oracle system triggers.

While the application is locked up a user can still get into Oracle through SQLPlus and run queries. So it may not be a database issue, but something with ASP.Net.

Have any one come across similar issues? any ideas will be appreciated?
Thanks in advance.

[quote]
ORA-04092: cannot COMMIT in a trigger
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: ORA-04092: cannot COMMIT in a trigger

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[OleDbException (0x80004005): ORA-04092: cannot COMMIT in a trigger]
   System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr) +41
   System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) +174
   System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) +92
   System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) +65
   System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +112
   System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) +69
   STRNet.Str.SealBase.GetDataRO(String SQL) in c:\inetpub\wwwroot\STRNet\Components\SealBase.vb:23
   STRNet.Str.SealTR.ValidateUser(String Uname, String Pwd) in c:\inetpub\wwwroot\STRNet\Components\SealTR.vb:1307
   STRNet.STRLogin.LoginUser() in c:\inetpub\wwwroot\STRNet\STRLogin.aspx.vb:59
   STRNet.STRLogin.btnLogin_Click(Object sender, EventArgs e) in c:\inetpub\wwwroot\STRNet\STRLogin.aspx.vb:66
   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
   System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
   System.Web.UI.Page.ProcessRequestMain() +1277
[/quote]