DevTest JDBC step with DB stored procedure call fails with: Missing IN or OUT parameter
book
Article ID: 185571
calendar_today
Updated On:
Products
CA Cloud Test MobileCA Application Test
Issue/Introduction
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
Environment
Release : 10.5
Component : CA Service Virtualization
Resolution
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.