Aug 17, 2017 03:10 AM|Deepak Panchal|LINK
I can see that you are not passing the value when you execute it in sql
exec @ret = LOCAL3_CheckAuth @login_id, @login_pw, @ip, @grade output, @species output, @bill_no
can you try to pass it like below.
exec @ret = LOCAL3_CheckAuth @login_id='abc', @login_pw='xyz', @ip='184.108.40.206', @grade output='demovalue', @species output='demovalue', @bill_no=1234
try to check it on your side and let us know whether it work for you or not.
if you can successfully execute it in SQL then you can also call it from code.