Execute store procedure result set error

Question

Hi, 
 I am using a Execute Stored Procedure smart service and it is returning 2 result set and each result set is returning with multiple values. 
 Now, when I try to grab the store procedure output result into a variable like below, I am getting an error. 
 An error occurred while evaluating expression: keys:AC!ResultSets[0] (Invalid index (0) for list: valid range is 1..2) (Data Outputs)

Sanchit Gupta (Xebia) · Answer

The error message is pretty clear that you are trying to index at 0 position but the valid indexes are 1 and 2, use ac!ResultSets[1]

Mike Schmitt · Answer

Unknown said: I suggest to call that SP in an interface 
 I'd go one step further and suggest wrapping it in an expression rule. Once that rule is up and running (and this is very easy to test as needed), you can use it anywhere easily - interface, process model, etc.

Sanchit Gupta (Xebia) · Answer

You were trying to store this result in a pv! of Integer array type. 
 Change the type of pv! to Map and keep it multiple.

Mike Schmitt · Answer

Depending on your use case, you could either output to a "Map" type PV as already suggested, or alternatively, specify a property of the expression rule output in order to make the expression rule actually return something closer to your list of integer (which might be more useful if the only thing that'll ever be relevant about the procuedure's output is the list of IDs it outputs).

Mike Schmitt · Answer

swapnar6405 said: When I am trying to convert from list of map to list of integers, I am getting an error. 
 You wouldn't simply use "tointeger()" for this. But if you want specific advice you'll need to show us what you're actually currently trying to do in the rule output.

Execute store procedure result set error

Top Replies