Return Out Paramter from SQL stored Proc and how to handle it in clle prog

[satya]

HellO everyone ,

I have created a stored proc that takes an inp parameter validates it against a table .Now i want to return a value/paramter from this sql stored proc so ithat i can check the same in my calling CLLE program .How do i handle this ?

Pls Note the caller is a clle program I have tried to use parameter marker but its not allowed .Please can anyone help .

What are my other alternatives.

[Vectorspace]

CLLE programs cannot directly call SQL procedures, they must be using a command or something else. What method are you using to do the SQL call?