SP Out Parameter value

Database
N/A

SP Out Parameter value

Hi,
I have created a SP with one OUT parameter. Please tell me how to call this SP in order to test and see the value of the OUT parameter in output screen.

Please suggest inputs or code snipsets.

Regards
Nits
2 REPLIES

Re: SP Out Parameter value

In your ODBC settings, there a an option called "Return Output Parameters As ResultSet". Make sure that option is checked. Then, you can call the stored procedure in SQL Assistant and the output parameters will be displayed as an answer set.

Good luck!

Re: SP Out Parameter value

it's really interesting and i want to learn more about it and i am looking forward to work on this DBMS.