Re: Inconsistent SELECT results

From: Ramon F Herrera <ramon_at_conexus.net>
Date: 13 Jul 2003 09:30:39 -0700
Message-ID: <c9bc36ff.0307130830.5609c1bb@posting.google.com>

Jim,

my results are more complicated. Sometimes I get the correct number of rows, while most of the time a lot of rows are missing. BTW: I didn't know you could get multiple rows at a time. Could you or other reader send a pointer to this "array interface"?

-TIA, -Ramon

"Jim Kennedy" <kennedy-down_with_spammers_at_comcast.net> wrote in message news:<hEVPa.42229$OZ2.7639_at_rwcrnsc54>...
> Let me guess you are using the array interface in OCI and fetching 10 or 11
> rows at a time. So count(1) works because it tells you that the row count
> is 910 rows and it only has 1 row. The other query is returning those rows
> but you are probably just fetching 1 time and since you are probably using
> the array interface and have it defined for 11 rows you are getting the 1st
> 11 rows of the result set. (The array is probably defined as x[10] which
> means 11 elements since in C arrays start at 0.)
> Jim
>
Received on Sun Jul 13 2003 - 11:30:39 CDT