java.sql.SQLException: Invalid column index error in DevTest JDBC step

Products

• Service Virtualization

Issue/Introduction

The following error is shown for a DevTest JDBC step:
java.sql.SQLException: Invalid column index
 at oracle.jdbc.driver.OraclePreparedStatement.setStringInternal(OraclePreparedStatement.java:5250)
 at oracle.jdbc.driver.OracleCallableStatement.setString(OracleCallableStatement.java:4664)
 at oracle.jdbc.driver.OraclePreparedStatementWrapper.setString(OraclePreparedStatementWrapper.java:255)
 at com.itko.lisa.jdbc.JDBCType$1.setParameter(JDBCType.java:43)
 at com.itko.lisa.jdbc.JDBCNode.makeStoredProcCall(JDBCNode.java:538)
 at com.itko.lisa.jdbc.JDBCNode.executeSQL(JDBCNode.java:392)
 at com.itko.lisa.jdbc.JDBCNodeEditor.doExec(JDBCNodeEditor.java:485)
 at com.itko.lisa.jdbc.JDBCNodeEditor$6.doCallback(JDBCNodeEditor.java:419)
 at com.itko.util.swing.panels.ProcessingDialog$2.run(ProcessingDialog.java:195)
 at java.lang.Thread.run(Thread.java:748)

Environment

Release : 10.7
Component : DevTest Workstation

Resolution

For a DB Procedure call in the JDBC step in DevTest 10.7, list all parameters in the Parameter panel and also in the SQL Statement itself.
For example for a db procedure with 4 parameters:
call my_db_proc(?,?,?,?)