jneth
New Contributor
Joined 8 years ago
User Profile
User Widgets
Contributions
Not able to call stored procedure
Hello, 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. Thanks in advance for anyone's help.Solved1.2KViews0likes1CommentRe: Parameters in Multipart Form Data Request
I understand the Get Data function. As mentioned above, I use it in other areas. I figured out the payload part of my question, but I am just not sure what to pass in the get data for the attachment file name as I mentioned above.4.2KViews0likes1CommentParameters in Multipart Form Data Request
I am creating a REST project that will be for a multipart form data request. I am trying to make it as simple as posible so that other testers on my team would not have to change too much. I was wondering if there is a way to parameterize the query parameters. I have two query parameters that I would like to do this with. First, the file attachment. Is there a way after attaching the file to the request through the attachments tab to pass the file name to the query parameter? I know it is minor, I am just trying to avoid having to have others attach the file and then add the file name to the query parm. Ideally, I want to see something like value = file:${#AttachmentFileName} for a query parm. Second, the payload. Similar question to above. I would want to pass values into the payload. I know that I can right click and get data from a previous test step, but there are a couple challenges with that. First, everytime you right click and get data, Ready API clears any existing data in the value. So, I would have to build the entire payload outside of Ready API and paste it back into the value of the query parm. Secondly, the value is one box and formats the payload in one long string, making it very hard to read. Is there a way that I could use the text box below the Media Type down box/ Post Query String check box and pass the contents of that back to query parm? I have attached screen shots of the areas that I am referring to in case it is not clear. Thanks in advance for any help.4.3KViews0likes3Comments