Unanswered: calling one stored proc from another stored proc using bind variable??
I'm tryin to call -this stored proc:
CREATE OR REPLACE PROCEDURE REACTIVATE_EMP_ASSESSMENT(p_empstr IN varchar, p_retriever_emplid IN varchar, p_activation IN varchar, p_out OUT VARCHAR2)
from within this stored proc:
CREATE OR REPLACE PROCEDURE CLOSE_ASSESSMENT(p_assidstr IN varchar, p_closed_reason IN varchar,p_closer_emplid IN varchar)
I have a number of variables defined in the second stored proc that I'm passing in as the parameters for the first stored proc. but I'm having issues with passing in the variable for the out parameter (p_out)