I'm getting "no current record for fetch operation" message for every
JOIN based solution. I had tried similar ones before and got the same
result, that's why I posted the question to the forum in the first
place.
The version I'm using is 1.5 RC6, if these joins should work, someone
might want to have a look...
Thanks for you all for the help.
Adam

<rvellacott@p...> wrote:

> Here is an odd but effective and efficient way of doing it
>
> SELECT A.*, SP.SP_RESULT FROM TABLE_A A
> JOIN MY_SP(A.INPUT_PARAM_1,A.INPUT_PARAM_2,etc) SP
> ON 1 = 1
>
> It's not documented, but it works.
>
> Roger Vellacott