| Subject | How to call a SP in another SP both with return parameters |
|---|---|
| Author | flipmooooo |
| Post date | 2005-02-08T16:35:55Z |
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))
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))