Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Select Intermittently Returning Incorrect Number of Rows
Steve wrote:
> Hi all, I'm hoping somebody can help me with this or give me a pointer
> in the right direction. I am running 8.1.7.4 Standard Edition,
> occasionally a select returns the incorrect amount of rows, the same
> string executed immediately after is invariably correct. Even a
> select count followed by a select can occasionaly return a different
> number of rows.
>
> This is really giving some headaches, I have a TAR open with Oracle
> but I though I would check here first. Thanks for reading
>
> -Steve156
>
> Steve
> www.chollie.com
> UKMG/MRBPF!C!H?S E4A1 GAS+/-- C= P+ G- B-- R- M= S= r+
Does the number of rows go up/down by one ... or by a bigger number? Is
someone else inserting/deleting rows (with a commit) between your two
selects? Is a trigger firing and inserting/deleting rows between your
two selects?
Received on Mon Jan 13 2003 - 12:48:09 CST