Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Why have I been receiving the following error message from my Oracle 8 server when using a FOR UPDATE statement: ORA-01002: fetch out of sequence?

April 26, 2017Error message ORA-01002 Oracle server

0

Posted

Why have I been receiving the following error message from my Oracle 8 server when using a FOR UPDATE statement: ORA-01002: fetch out of sequence?

1 Answer

0

Posted

There is a problem in the Oracle 8 server that causes this error when using a FOR UPDATE statement with AUTOCOMMIT turned on (which is the default state when using JDBC). This is known to happen on Oracle 8.0 and 8.1 on Solaris and on Oracle 8.1 on Windows NT. If you turn AUTOCOMMIT off, you will not receive this error. Since this problem is due to a change in the Oracle 8 server, you should contact Oracle support for more information. OCIW32.DLL error I have been receiving the following error message when using your JDBC driver for Oracle: “The ordinal 40 could not be loaded in the dynamic link library OCIW32.dll” This problem is caused by an out-of-date version of OCIW32.DLL in your system directory. Some programs install this file in the system directory in order to run. If you remove this file from the system directory you should no longer receive this error.