日期:2014-05-17  浏览次数:20793 次

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