11 years ago
MSSQL Stored Procs with output - how to run
I have searched the forum for this, and have found a few threads, but so far none answer this question. I am pretty new to SOAP UI, so maybe it is because I don't have the experience yet.
Can someone tell me the EASIEST way (or maybe the BEST way) - I'll listen to both - way to run a MSSQL stored proc that has two input parameters (need to pass in null for these) and one output paramenter which is a new document ID (integer). This should be simple. So far, it hasn't been.
I have tried using a JDBC step and a Data Source step, neither worked. I think I tried using Groovy too, but didn't get real far with that because of my experience level. Also, I have NO idea what the "Select if this is a stored procedure" checkbox means/does on the JDBC step.
I would be so thankful if someone could walk me through this. Many things that I have seen on here don't go into details about the output parameter, which is key for me.
Can someone tell me the EASIEST way (or maybe the BEST way) - I'll listen to both - way to run a MSSQL stored proc that has two input parameters (need to pass in null for these) and one output paramenter which is a new document ID (integer). This should be simple. So far, it hasn't been.
I have tried using a JDBC step and a Data Source step, neither worked. I think I tried using Groovy too, but didn't get real far with that because of my experience level. Also, I have NO idea what the "Select if this is a stored procedure" checkbox means/does on the JDBC step.
I would be so thankful if someone could walk me through this. Many things that I have seen on here don't go into details about the output parameter, which is key for me.