Find answers to ORA-01002: fetch out of sequence ORA-02063: preceding line from dblink from the expert community at Experts Exchange
ORA-01002: fetch out of sequence 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:...
Oracle 通过 gateway dblink 打通和 sqlserver的连接。用户能够直接访问oracle获得sqlserver的数据。 关键问题 select * from dbo.Alarm@LINK_ASDWMS > ORA-01002: fetch out of sequence ORA-02063: preceding line from LINK_ASDWMS > 时间: 0.353s
b. SQL_AUTOCOMMIT_ON=1 c. SQL_NTS=-3 4. SQLExecute the stmt: "SELECT * FROM sysobjects@<databaseLink>" 5. SQLGetData 6. Error returned, "[DataDirect][ODBC Oracle driver][Oracle]ORA-01002: fetch out of sequence ORA-02063: preceding line from ,<databaseLink>". 7. Disconnect. 8. C...