Ravindra,

Once you have a connection handle to SQL server, you can use the following code to return a value. You must initially create the variable before calling the stored procedure.

lcReturnValue = SPACE(11)
= SQLExec(lnHandle,"{CALL sp_name (?@lcReturnValue)}")

hth,
Kurt