Hi, I am trying to use "Execute Stored Procedure" however I am no

As a first check, please confirm all the params mentioned in your stored proc as IN should be exactly the same in the input of the smart node and with the same data type. Any mismatch would result in wrong mapping.. If your cdt is not big enough then you can also try defining the child elements of cdt as individual params and try. Am quite sure if your stored proc is behaving as desired and only the inputs are causing the probs then it should be mismatch in the param name and types.

also please check that Result sets not returned through an OUT parameter can be obtained by naming the ACP resultSet1, resultSet2, etc, depending on which result set is required. MySQL and SQL Server must have result sets returned this way.

@sumitp
Yes, my IN parameter name is same as my procedure parameter name. In case of as you are saying to use child parameter I have to modify the procedure parameter name too. Am I right?

@harshav
I am using resultset1 however I am not getting any value...