Execute Stored Procedure Plugin function in SAIL: After an update to a stored proc, not returning all the fields required

Question

Hello! 
 
 I have a SPROC which is running fine in MS SQL Server. 
 Initially I had 16 columns to retrieve data. Now, I have updated the SPROC and added some more columns to be retrieved. 
 However, the SPROC is running fine in SQL server but it's not returning all the required columns data. 
 
 For eg. Lets say, I have a SPROC which returns data for columns c1, c2, c3 and c4. When you call this from Appian, it is returning all the 4 columns. But when I updated the same SPROC with additional 4 columns to be retrieved. It does not do that. What might be the cause behind this? Thank you in advance!

Omkar K · Accepted Answer

sagarl511 : I did try calling the same stored proc with same name and different name also. No aggregation involved. 
 
The solution to this issue is that convert your columns or input parameters or output parameters to nvarchar. I think, the plugin works best with string or text or nvarchar data types. Thank you all!