Execution of Stored Procedure does not return value problem
If you have developed a Stored Procedure and unexpectedly it does not return value you may consider to check the parameter definitions of your SP.
I was omitting the size of the nvarchar type parameters and after defining size of nvarchar parameters my Stored Procedures worked as expectedly.
So, If you are facing an issue like that you may want to define size of nvarchar parameters like following definition.
Hope that helps!