ORA-01002: 读取违反顺序 怎样解决？

[qzg168]

执行下列语句时出现：ORA-01002: 读取违反顺序错误：
String cmd = "SELECT CONTENT FROM BLOBTEST WHERE filename='row3' FOR UPDATE";
ResultSet rest = st.executeQuery(cmd);

[iliepeng]

@mycode 给这个错误折腾一整天了，谢谢

[mycode]

也许访问数据库的模式是隐式提交的方式,即每一个SQL语句执行时,就自动的Commit,这样就发生这样的错误.改一下就可以了.

[thingsfly]

你这是用的什么开发工具??

[thingsfly]

你这是用的什么开发工具??

[qzg168]

JBuilder6

[flowerofwind]

01002, 00000, "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:
// 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 the SQL statement, 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.

[flowerofwind]

意思是说可能你提交了后然后又进行了fetch炒作，或者数据集已经取完了，oracle报告了"found no data"后，你又一次fetch，所以发生了这个错误

[lhsoft]

谢谢你的答案，mycode。