You seem to have this figured out so I will run my issue by you.
I have a similar issue where I have to run a stored procedure to retrieve the data. I need to be able to use a variable such as $CustClaimNumber which is retrieved from the caller via the CRS script and pass it to the stored procedure in order to get the Claim Status. When I run the script using the SQL syntax below I hit the DB Error step. If I hard code the claim ID instead of using a variable the store procedure works. Using my query against your solution I can see that you pass (my variable) of Claim Status, but what I need to pass is the Claim ID as collected in the script as $CustClaimNumber.
We already have a view created which allows us to store the retrieved result and that works in the DB Get step, I just need to figure out how to change the claim id to a variable that I can pass to the procedure.
DECLARE @Claim_Status nvarchar(5); EXEC IVR_GetStatusByClaimID_OUTPUT @ClaimID = $CustClaimNumber ; @Status = @Claim_Status OUTPUT; SELECT @Claim_Status as N'Claim_Status'
How and where do you configure this "view" to store the retrieved value from the Store Procedure?
... View more