How to fetch values from stored procedure

Hi,

I have created a stored procedure in SQL.

If I call that SP without returning the values, I am able to call that stored procedure in X++.

But I want to return value from stored procedure and fetch it in X++.

In SQL , it shows me correct value, but I am not able to get values in X++.

Any idea…