ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

DevTest JDBC step with DB stored procedure call fails with: Missing IN or OUT parameter


Article ID: 185571


Updated On:


CLOUDTEST CA Application Test CA Cloud Test Mobile MOBILECLOUD Service Virtualization


When testing a JDBC step with a database procedure call that contains a ? (question mark) as a parameter, the step fails with the following error: 
java.sql.SQLException: Missing IN or OUT parameter at index:: 2


Release : 10.5

Component : CA Service Virtualization


For a stored procedure call in the JDBC step, all parameters should be listed in the parameter panel and not in the statement itself.
In a SQL statement like SELECT or INSERT, it is possible to use a question mark.

Additional Information