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