前段时间，监控每天晚上跑的etl程序，发现有个程序报ora-01002: 提取违反顺序的错误。 oracle的官方文档里对这个错误的解释是： cause: this error means that a fetch has been attempted from a cursor which is no longer valid. note that a pl/sql curso
前段时间，监控每天晚上跑的etl程序，发现有个程序报ora-01002: 提取违反顺序的错误。
oracle的官方文档里对这个错误的解释是：
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 thesqlstatement, then issuing a fetch before reexecuting the statement.
action: 1) do not issue a fetch statement after the last row has been retrieved - there are no more rows to fetch. 2) do not issue a commit inside a fetch loop for a cursor that has been opened for update. 3) reexecute the statement after rebinding, then attempt to fetch again.