Hi!

I have a single row selectable Stored Procedure with several output
parameters. I wonder, when I use this SP in a query like this:

select
s.id,
(select computation1 from SP (s.id)) as computation1,
(select computation2 from SP (s.id)) as computation2,
(select computation3 from SP (s.id)) as computation3
from stuff s

Does Firebird 1.5 execute SP three times per row or does it collect
all computations with one pass?

Is subselect the only possibility to get results from one row SP into
several row query?

I tried to join this SP into query but engine (or maybe client?)
complained about "no current row".

Thank you!

Aivar