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