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: Select Intermittently Returning Incorrect Number of Rows

Re: Select Intermittently Returning Incorrect Number of Rows

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 14 Jan 2003 14:15:13 -0000
Message-ID: <3e241b72$0$246$ed9e5944@reading.news.pipex.net>


"Steve" <sjc_at_NOSPAM.chollie.com> wrote in message news:97582v8gjd0rst85kilstltvvccbc02b9r_at_4ax.com...
> I also very much doubt that it is fully down to Oracle, it wouldn't be
> where it was if it was incapable of a simple select,I suspect it may
> be the application enviroment (possibly the middleware), but all tests
> have so far *seemed* to show that this is what is returned by the
> server.

Can you replicate the problem just using sql+ ? The other thing that you could consider doing is setting sql_trace=true for the session that is affected, this would tell you for sure if the sql was changing between calls.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************
Received on Tue Jan 14 2003 - 08:15:13 CST

Original text of this message

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