17,086
社区成员
发帖
与我相关
我的任务
分享[求助]什么情况下会出现ORA-01002:fetch out of sequence的错误
存储过程中使用Cursor，在什么情况下会出现ORA-01002:fetch out of sequence的错误？我测试了一些语句，都没有找到这样的错误，请各位帮忙，或者能否提供一些例子，谢谢！
...全文
请发表友善的回复…
发表回复
snowy_howe 2004-01-11
- 打赏
- 举报
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.
最好能把存储过程贴出来，方便分析。
