ORA-01002 fetch out of sequence
Cause: In a host language program, a FETCH call was issued out of sequence. A successful parse-and-execute call must be issued before a fetch. This can occur if an attempt was made to FETCH from an active set after all records have been fetched. This may be caused by fetching from a SELECT FOR UPDATE cursor after a commit. A PL/SQL cursor loop implicitly does fetches and may also cause this error. Action: Parse and execute a SQL statement before attempting to fetch the data.
Cause: In a host language program, a FETCH call was issued out of sequence. A successful parse-and-execute call must be issued before a fetch. This can occur if an attempt was made to FETCH from an active set after all records have been fetched. This may be caused by fetching from a SELECT FOR UPDATE cursor after a commit. A PL/SQL cursor loop implicitly does fetches and may also cause this error. Action: Parse and execute a SQL statement before attempting to fetch the data.
解决方案 »
- 关于海量数据求最晚时间的问题
- 建ORACLE时存储空间该如何规划!
- 急、急、急,各位大虾,关于ORacle表只读权限问题
- oracle rman 备份出错。求指点。
- 有没有高手对sql和oracle在事务中的锁的机制有深刻地了解,最好能有事例做演示
- 类似SQL Server中的自动增长的列?急盼高手解决!在线等待
- 关于触发器更改标志位问题,急,万分感谢
- 触发器select 问题
- 异常“必须声明标识符 ” 网上的答案没效果啊!!!好心人进来看一看
- ORA11G数据库数据数据状态翻转不了可能是什么问题
- 我打算学ORACLE,请各位建议一下学什么样的教材?
- ORACLE与ACCESS高级应用,各种疑问求解有经验人士
在java的板块多看看blob吧
顺便问一下 你用的weblogic嘛 看样子不像