Subject | RE: [firebird-support] Re: call stored procedure from another one. |
---|---|
Author | Maya Opperman |
Post date | 2008-10-03T15:29:08Z |
>> EXECUTE PROCEDURE SPS_CASE_CUR_BAL(V_ACCT_ID, iCaseID, NULL, 0)curCasePreIntBal, curCasePostIntBal,
>> RETURNING_VALUES curCaseBal, curCasePrincBal,
>> 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;