Subject RE: [firebird-support] Re: call stored procedure from another one.
Author Maya Opperman
>> EXECUTE PROCEDURE SPS_CASE_CUR_BAL(V_ACCT_ID, iCaseID, NULL, 0)
>> RETURNING_VALUES curCaseBal, curCasePrincBal,
curCasePreIntBal, curCasePostIntBal,
>> curCaseTotalFeeBal, curCaseFeeBal,
curDebtFeeBal;

But why is this faster/better than:

Select FieldX, FieldY, FieldZ
from SPS_CASE_CUR_BAL(V_ACCT_ID, iCaseID, NULL, 0)
into curCaseBal, curCasePrincBal, curCasePreIntBal;