Subject Re: [IBO] Difference between using ib_query or ib_storedproc for a select procedure
Author Lucas Franzen
Gerhardus Geldenhuis schrieb:
> Hi
> I just want to know is there any difference in terms of
> speed/effectiveness/etc in using a ib_query to, with the following
> select * from myproc(:var1,:var2) than using a ib_storedproc component
> to do the selection.

TIB_Query are for returning multiple rows, so your SP must contain
SUSPEND to return multiple rows.
IB_StoredProcs are for returning ONE row (a set of fields) and the SP
shouldn't contain SUSPEND in that case.