Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Inconsistent SELECT results

Re: Inconsistent SELECT results

From: Jim Kennedy <kennedy-down_with_spammers_at_no_spam.comcast.net>
Date: Sun, 13 Jul 2003 16:53:45 GMT
Message-ID: <t8gQa.48459$sY2.21776@rwcrnsc51.ops.asp.att.net>


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...

> 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:53:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US