代码如下:
Int32 getnu; System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection(System.Configuration.ConfigurationManager.AppSettings["connstr"]);
System.Data.OleDb.OleDbDataReader mysdr;
System.Data.OleDb.OleDbDataReader mysdr1;
string sql = "select count(*) from xxx where id='" + dropdownlist1.SelectedItem.Value.ToString() + "'";
System.Data.OleDb.OleDbCommand mycmd = new System.Data.OleDb.OleDbCommand(sql, conn);
conn.Open(); mysdr = mycmd.ExecuteReader(); mysdr.Read();
getnu=Convert.ToInt32(mysdr[0].ToString());
for (int i=0;i<getnu;i++)
{
string sql1="select lpad(seq_no.nextval,3,'0') from dual";
System.Data.OleDb.OleDbCommand mycmd1 = new System.Data.OleDb.OleDbCommand(sql1, conn); mysdr1 = mycmd1.ExecuteReader();
mysdr1.Read();
DateTime dt = DateTime.Now;
string getdatev = dt.ToString("yyMMddhhmmss");
string uid = getdatev + mysdr1[0].ToString();
Response.Write(i + ":" + uid + "<br>");
}
mysdr.Close();
conn.Close();
conn.Dispose();运行这段代码后系统报:
ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded这是怎么回事?如何解决?!急用,谢谢了
Int32 getnu; System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection(System.Configuration.ConfigurationManager.AppSettings["connstr"]);
System.Data.OleDb.OleDbDataReader mysdr;
System.Data.OleDb.OleDbDataReader mysdr1;
string sql = "select count(*) from xxx where id='" + dropdownlist1.SelectedItem.Value.ToString() + "'";
System.Data.OleDb.OleDbCommand mycmd = new System.Data.OleDb.OleDbCommand(sql, conn);
conn.Open(); mysdr = mycmd.ExecuteReader(); mysdr.Read();
getnu=Convert.ToInt32(mysdr[0].ToString());
for (int i=0;i<getnu;i++)
{
string sql1="select lpad(seq_no.nextval,3,'0') from dual";
System.Data.OleDb.OleDbCommand mycmd1 = new System.Data.OleDb.OleDbCommand(sql1, conn); mysdr1 = mycmd1.ExecuteReader();
mysdr1.Read();
DateTime dt = DateTime.Now;
string getdatev = dt.ToString("yyMMddhhmmss");
string uid = getdatev + mysdr1[0].ToString();
Response.Write(i + ":" + uid + "<br>");
}
mysdr.Close();
conn.Close();
conn.Dispose();运行这段代码后系统报:
ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded这是怎么回事?如何解决?!急用,谢谢了
解决方案 »
- asp.net邮件群发怎么实现
- 客客,这个何意 ((\d+)\d*)\2
- 熟悉DataSource控件进来讨论下。
- 在一个***.aspx.vb页面里,就写一次数据库连接字符串。然后怎么调用?
- 急:装了2005后,asp.net1.1用不了
- 用DataGrid如果做出yahoo音乐盒的样子,就是每行下面再有一行说明的东西??
- 关于中国BBS社区100强投票,请大家多多宣传,多多投票啊
- asp.net 从页面传写入数据库中,用不用过滤'单引号?
- [CSDN首发]CSDN人回馈CSDN社区. 发布开源项目 aspnetcdn 第一个版本源代码. (ASP.NET做的CDN,为教学而生)
- 让 UserControl 的Page_Load先执行,可以吗?谢谢
- 郁闷,公司接的**银行的项目,我做不了。顶者有分。
- .NET 页面加载的疑问,等待高手解答?
现在你不是这样的. mysdr.Read();
getnu=Convert.ToInt32(mysdr[0].ToString());
没有及时关闭连接,马上就在一次读取别的内容了.