Re: OCI cursor

From: Arie Tuchfeld <arie_at_hyperbanner.net>
Date: Fri, 02 Jul 1999 13:03:32 +0200
Message-ID: <377C9C84.B613AC1E@hyperbanner.net>

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 - 06:03:32 CDT