OraDataTable Exceeding Cursors Problem

OraDataTable Exceeding Cursors Problem

Postby 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(""); // <<<

string backgroundColor = "#5E668D";

foreach(DataRow DTRow in myDataTable.Rows)
{
sb = sb.Append("");
sb = sb.Append("" );

//other string generation Code not shown

sb = sb.Append("");

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

LabelDataTable.Text = sb.ToString();

}
finally
{
myDataTable.Dispose();
}
pbright
 
Posts: 3
Joined: Tue 27 Sep 2005 18:48

Postby 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.
Paul
 
Posts: 725
Joined: Thu 28 Oct 2004 14:06


Return to dotConnect for Oracle