Or you use select if you have more then one row:

select * from your_cool_stored_procedure into ........


-----Ursprüngliche Nachricht-----
Von: Martijn Tonies [mailto:m.tonies@...]
Gesendet: Mittwoch, 28. Januar 2004 16:50
An: firebird-support@yahoogroups.com
Betreff: Re: [firebird-support] How to call a stored procedure in a stored procedure


Hi,

> could someone help me with the syntax on how to call a stored procedure
> in a stored procedure (I hope it's possible).

EXECUTE PROCEDURE name :param1, :param2
RETURNING_VALUES :paramout1, :paramout2

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com



Yahoo! Groups Sponsor

ADVERTISEMENT
<http://rd.yahoo.com/SIG=12ckgbtf7/M=267637.4116730.5333196.1261774/D=egroupweb/S=1705115386:HM/EXP=1075391331/A=1945638/R=0/*http://www.netflix.com/Default?mqso=60178383&partid=4116730> click here
<http://us.adserver.yahoo.com/l?M=267637.4116730.5333196.1261774/D=egroupmail/S=:HM/A=1945638/rand=786567918>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/


* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com <mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]