1.sqlcode = -1002 异常原因
官方解释:
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. |
在一个select for 循环中,如修改提交了数据,那么可能出现这个错误。