Hi!

Is it possible to join a stored procedure into a query?

I tried this:

select
t.id,
sp.some_calculation
from sometable t
join some_sp sp on (sp.id = t.id)
/* sp.id is procedure input param */

but only got "parameter mismatch" error

select
t.id,
sp.some_calculation
from sometable t,
some_sp (t.id)

was syntax error.

What is the correct way of using SP in a SELECT?

thanks in advance!

Aivar