| Subject | Re: [firebird-support] How to call a SP in another SP both with return parameters |
|---|---|
| Author | Urs Liska |
| Post date | 2005-02-08T17:36:22Z |
flipmooooo schrieb:
>EXECUTE PROCEDURE SP2(AID) RETURNING_vALUES :ERRORTEXT;
> Hi,
>
> How do i call a SP in another SP both with return parameters.
> in SP1 i need to do something like this but i don't know the right
> syntax: ERRORTEXT = EXECUTE PROCEDURE SP2(AID);
>
> Greetings,
> Filip Moons
>
>
> CREATE PROCEDURE SP1 (ID INTEGER) RETURNS (ERRORTEXT VARCHAR(40))
>
> CREATE PROCEDURE SP2 (ID INTEGER) RETURNS (ERRORTEXT VARCHAR(40))
>