Re: OCI cursor

after calling OCIStmtExecute (with iters = 0), iterate with OCIStmtFetch (with nrows = 1) until OCI_NO_DATA is returned,

Arie Tuchfeld wrote:
>
> Hi,
> I'd like to iterate through a query result using OCI interface.
> i.e. fetching each row at a time until the last result's row.
> How can it be done ?
> Currently, I use OCIDefineByPos() function to place the result into an
> array, but this way I need to know the number of rows in advance.
Received on Fri Jul 02 1999 - 13:03:19 CEST