Hi
I have created following procedure with OUT parameter, but it is not working.
Please help me to invoke the Procedure which has OUT parameter.



CREATE PROCEDURE SP_OUT_PARAM_1 (OUT p_ID INT)

LET p_ID = 99;
END PROCEDURE


CREATE PROCEDURE SP_OUT_PARAM_2 ()
DEFINE v_ID INT;

EXECUTE PROCEDURE SP_OUT_PARAM_1 (v_ID);

END PROCEDURE


Then when executing SP_OUT_PARAM_2 in DBAccess, following error shown--
9752: Argument must be a Statement Local Variable for an OUT/INOUT parameter


Then I have changed the argument of SP_OUT_PARAM_2 as follows

CREATE PROCEDURE SP_OUT_PARAM_2 ()

EXECUTE PROCEDURE SP_OUT_PARAM_1 (v_ID # INT);

END PROCEDURE

Now following error shown when compiling SP_OUT_PARAM_2

9781: SLV cannot be an argument to a function invoked explicitly by EXECUTE or CALL.

Thanks and Regards
Aloke