OraDataTable Exceeding Cursors Problem

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
pbright
Posts: 3
Joined: Tue 27 Sep 2005 18:48
Contact:

OraDataTable Exceeding Cursors Problem

Post by pbright » Tue 27 Sep 2005 18:57

This code is being called on the onPage load method of a webform. After about the 10th call I get the following error:

ORA-01000: maximum open cursors exceeded ORA-01000: maximum open cursors exceeded ORA-06512: at "SYS.DBMS_LOB", line 715 ORA-06512: at line 1

How to I get rid of this. I though dispose closed the connections. Thanks for any help on this.

The code:

OracleDataTable myDataTable =
new OracleDataTable("SELECT * FROM SomeTable",
Global.Globals.Configuration.ConnectionString );

try
{

myDataTable.Active = true;

System.Text.StringBuilder sb = new StringBuilder();

sb = sb.Append(""); // ");
sb = sb.Append(""+DTRow["Order_No"].ToString()+"" );

//other string generation Code not shown

sb = sb.Append("");

}
sb = sb.Append("");

LabelDataTable.Text = sb.ToString();

}
finally
{
myDataTable.Dispose();
}

Paul
Posts: 725
Joined: Thu 28 Oct 2004 14:06

Post by Paul » Thu 29 Sep 2005 09:02

We reproduced your problem and fixed it. This fix will be included in the next OraDirect .NET build.

Post Reply