I am trying to call a DB2 stored procedure in ReadyAPI, version 3.3.1. I have the "stored procedure" box on the JDBC query step selected. However, when I try to run the stored proc, I receive and error that The number of parameter values set or registered does not match the number of parameters.
I know I am passing the correct number of parameters. I am able to run the stored proc in an outside query tool successfully. I have tried a couple different ways to call it.
1. With the stored procedure box check - MyStoredProc('Parm1', 'Parm2', Parm3, ?, ?, ?) - Returns error mentioned above.
2. With the stored procedure box checked - call MyStoredProc('Parm1', 'Parm2', Parm3, ?, ?, ?) - Returns update count 0 in the results, but does not return the expected result set with the 3 OUT parameters.
Running call MyStoredProc('Parm1', 'Parm2', Parm3, ?, ?, ?) in outside query tool returns result as expected (3 OUT parameters)
Is this a bug or is anyone aware of a workaround? This seems to have broke as previous test cases that were working at one point, now fail as well with the same error regarding number of parameters.