Devart Forums

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();
}

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