Execute Stored Procedure is not taking multiple values as Input

Hi,

I am trying to use "Execute Stored Procedure" smart Service.  When I tried to use multiple values in input, it started failing by giving error "Invalid Column Type". For example, I have a stored Procedure on "Client". We have two inputs for the Stored Procedure. One is TaxPayer ID, second is Client Type. So we are Query for Client by Client Id for "Gold" or "Platinum" Client Type. So when we added Client Type as Multiple for {"Gold","Platinum"}. It started giving error. I can not use MNI as in some stored procedures we have multiple inputs with multiple values. Can anyone guide how can I fix this issue?

  Discussion posts and replies are publicly visible

Parents Reply Children