>
> I have a Stored Procedure converting some data and want to join with
> some other data from a regular select of another table
>
> Is it possible?
>
> SELECT A.FLD1, A.FLD2, SP.FLD1, SP.FLD2
> FROM TBL1 A
> JOIN MYSP(A.FLD3) SP ON SP.ID = A.ID
>
>
> The message I get is
> --
> The cursor identified in the update or delete statement is not
> positioned on a row.
> no current record for fetch operation.
> --
>
> Update? Delete? There is no Update nor Delete in the SP....

You can't use a field in one set as the input parameter to the SP.
Alan