eygle.com   eygle.com
eygle.com  
 
eygle.com - 留言簿 - 回复留言 - Powered by eYgLe.Com
返回留言簿
回 复 留 言
留言ID:
留言原文:
To:
  eygle,你好
 环境linux4+oracle10g+jdk1.5,数据库服务端是单机Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
 最近有个应用在测试环境下频繁出现ORA-01002错误,这个应用只是一个查询,数据量在3万左右,运行几十分钟后就出现此错误,该查询间隔30秒执行一次。以前没有出现此错误,最近出现频繁。查看官方文档:ORA-01002: fetch out of sequence
Cause: This error means that a fetch has been attempted from a cursor which is no longer valid. Note that a PL/SQL cursor loop implicitly does fetches, and thus may also cause this error. There are a number of possible causes for this error, including: 1) Fetching from a cursor after the last row has been retrieved and the ORA-1403 error returned. 2) If the cursor has been opened with the FOR UPDATE clause, fetching after a COMMIT has been issued will return the error. 3) Rebinding any placeholders in the SQL statement, then issuing a fetch before reexecuting the statement.
三种情况都不符合,不知老师有其他办法没有,不甚感谢!

sql语句是:select id,su_mdn from ve_target2 where id is not null and su_mdn is not null and active=1

Best regards!
From: zhouhuabin
2009.07.26 20:31
管理密码: 请输入管理密码, 否则无法回复.
斑竹昵称:
信息图标: ( 随机 )


BB 代码:
内容:

如果想删除回复, 请点击最下面的删除回复按钮.
删 除 回 复
管理密码: 请输入管理员密码, 只有版主才能删除回复.
Copyright © 2003~2012 eygle.com All Rights Reserved.
Powered by: www.eygle.com