--- In ib-support@yahoogroups.com, Alexander Tabakov <saho@e...>
wrote:

> "select
> party.party_id, profile.*
> from
> tbl_party party, read_profile(party.party_id) profile"
>
> where "read_profile" is a stored procedure prepares OK but on

execution I receive:

> "The cursor identified in the update or delete statement is not

positioned on a row.

> No current record for fetch operation"
>
> BUT,
>
> The folowing query executes OK:
>
> "select
> party.party_id, profile.*
> from
> tbl_party party LEFT JOIN tbl_party party2 on (party.party_id =

party2.party_id),

> read_profile(party.party_id) profile"
>
> The magic is in the LEFT JOIN. A simple join doesn't work, I get the
> same error.
>
> Any ideas?

http://www.krista.ru/ib/proc-join.html

I hope you can read Russian ;)

Best regards, Alexander.