Why does FOR UPDATE in Oracle 8 cause an ORA-01002 error?

Submitted by: Administrator
The Oracle 8 server generates an ORA-01002:fetch out of sequence error message when you use 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. Because this problem is due to a change in the Oracle 8 server, you should contact Oracle support for more information.
Submitted by: Administrator

Read Online BEA Weblogic Job Interview Questions And Answers