Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Inconsistent SELECT results
It is in the documentation, the developer's guide.
Jim
-- Replace part of the email address: kennedy-down_with_spammers_at_attbi.com with family. Remove the negative part, keep the minus sign. You can figure it out. "Ramon F Herrera" <ramon_at_conexus.net> wrote in message news:c9bc36ff.0307130830.5609c1bb_at_posting.google.com...Received on Sun Jul 13 2003 - 11:53:45 CDT
> 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
> >
![]() |
![]() |