Getting ORA-01002 Fetch out of Sequence error while running simple insert query in Devtest JDBC step

Document ID : KB000009006
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

We are receiving ORA-01002 Fetch out of Sequence error while running simple insert query. 

    Insert query inserts the data in oracle DB in  respective table but DevTest end we are receiving Fetch out of sequence error. 

Below is the Error stack 
java.sql.SQLException: ORA-01002: fetch out of sequence 

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) 
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) 
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059) 
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522) 
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257) 
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587) 
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225) 
at oracle.jdbc.driver.T4CPreparedStatement.fetch(T4CPreparedStatement.java:1066) 
at oracle.jdbc.driver.OracleStatement.fetchMoreRows(OracleStatement.java:3716) 
at oracle.jdbc.driver.InsensitiveScrollableResultSet.fetchMoreRows(InsensitiveScrollableResultSet.java:1015) 
at oracle.jdbc.driver.InsensitiveScrollableResultSet.absoluteInternal(InsensitiveScrollableResultSet.java:979) 
at oracle.jdbc.driver.InsensitiveScrollableResultSet.next(InsensitiveScrollableResultSet.java:579) 
at com.itko.lisa.jdbc.JDBCResultSetCache.getRowData(JDBCResultSetCache.java:61) 
at com.itko.lisa.jdbc.JDBCResultSetCache.<init>(JDBCResultSetCache.java:54) 
at com.itko.lisa.jdbc.JDBCNode.makeGenericCall(JDBCNode.java:463) 
at com.itko.lisa.jdbc.JDBCNode.executeSQL(JDBCNode.java:387) 
at com.itko.lisa.jdbc.JDBCNodeEditor.doExec(JDBCNodeEditor.java:483) 
at com.itko.lisa.jdbc.JDBCNodeEditor$6.doCallback(JDBCNodeEditor.java:417) 
at com.itko.util.swing.panels.ProcessingDialog$2.run(ProcessingDialog.java:194) 
at java.lang.Thread.run(Thread.java:745) 

Resolution:

The issue was happening due to "Returns Result Set" checkbox selected in the JDBC step. This option should be selected only when a result set is expected to be returned by the query like with a SELECT statement. 

when a result set is expected to be returned by the query like with a SELECT statement. 

Additional Information:

For more information, please refer below documentation link:

https://docops.ca.com/devtest-solutions/10-1/en/reference/test-step-descriptions/other-transaction-steps/sql-database-execution-jdbc