ORA-01000: 超出打开游标的最大数！！ 在线急等！
static void Main(string[] args)
{
DateTime begin = DateTime.Now;
OracleDataReader odr = null;
OracleConnection conn = null;
int i = 0;
for (int j = 0; j < 10;j++ )
{
try
{
Console.WriteLine("start");
string connsql = "Data Source=(DESCRIPTION =" + "(ADDRESS = (PROTOCOL = TCP)(HOST = 129.129.129.16)(PORT = 1521))" + "(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = orcl) ) );" + "User ID=tcyb_sjqy;PassWord=tcyb_sjqy;Unicode=True";
conn = new OracleConnection(connsql);//创建一个新连接?
conn.Open();
OracleCommand cmd = conn.CreateCommand();
cmd.CommandText = "select t.jtbh,t.xm,t.ylzh, t.rowid from yw_cb_grjbzl t where t.yzbm is null ";//在这儿写sql语句?
odr = cmd.ExecuteReader();
Console.WriteLine("Conn 已经打开");
while (odr.Read())
{
String YLZH = odr.GetOracleString(2).ToString();
cmd.CommandText = "update yw_cb_grjbzl t set t.yzbm = '" + MathExample.GetStrMiWen(YLZH) + "' where t.ylzh = '" + YLZH + "'"; //MathExample.GetStrMiWen(YLZH) 此处调用了个加密算法
cmd.ExecuteReader();
Console.WriteLine(i++);
}
cmd.Dispose();
odr.Dispose();
conn.Dispose();
odr.Close();
conn.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
finally
{
odr.Close();
conn.Close();
}
}
TimeSpan ts = DateTime.Now - begin;
Console.WriteLine("ts = " + ts.TotalMilliseconds);
Console.ReadKey();
}
执行到299 就报“System.Data.OracleClient.OracleException: ORA-01000: 超出打开游标的最大数” 的错误 ，忘各位大虾能给解决下 ，新手求指点！！最好能给个成功的例子！！谢谢！！
[解决办法]
while (odr.Read())
{
....
//cmd.ExecuteReader();
cmd. ExecuteNonQuery();
....
}
cmd.ExecuteReader(); cmd.ExecuteNonQuery();
Console.WriteLine(i++);
}
