SQL Store procedure incomprehensible issue

i have a problem with a Store Procedure that works fine in sql server working with the same parameters that i use in the web application, but in the application don't return a result. Why could be this problem? any help would be appreciated.