search cancel

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 Mobile CA Application Test Service Virtualization

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.x

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.

Additional Information

https://techdocs.broadcom.com/us/en/ca-enterprise-software/devops/devtest-solutions/10-7/reference/test-step-descriptions/other-transaction-steps/sql-database-execution-jdbc.html