ORA-01002: 提取违反顺序的问题分析

前段时间，监控每天晚上跑的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.IMP-00008: unrecognized statement in the export file: string的问题分析ORA-00600: internal error code, arguments: [kqlnrc_1], [0x70000029A6C9410], [],相关资讯 Oracle错误代码

Oracle错误代码大全（02/16/2015 21:31:57）
Oracle中登陆时报ORA-28000: the （03/06/2013 20:06:23）
Oracle 11g startup时报ORA-03113 （02/21/2013 17:25:55）

Oracle Grid Control OUI-25031错（03/09/2013 09:01:36）
ORA-04091:触发器/函数不能读（02/25/2013 08:28:13）
Oracle错误 ORA-12514 解决方法（02/18/2013 08:50:10）

本文评论查看全部评论（0）