Unanswered: Problem when calling a stored procedure from within another
I have a stored procedure that loops through a cursor and then needs to call another procedure with a value from the cursor as an input.
Here is the section of my main procedure that deals with it:
Elsif v_transType = 'A' then
-- If the transtype is an adjustment loop through each adjustment,
-- passing the applyto transno into p_glAdjust procedure to write reversals to GL CONTROL
FETCH c_bill INTO r_bill;
EXIT WHEN c_bill%NOTFOUND;
when I compile the entire main Stored Procedure (p_glAdjust is already compiled) it returns the error:
Error(481,10): PLS-00103: Encountered the symbol "P_GLADJUST" when expecting one of the following:
:= . ( @ % ; The symbol ":=" was substituted for "P_GLADJUST" to continue.
can anybody suggest what I am doign wrong.
Is it not possible to call another procedure in this manner?