Re: Select Intermittently Returning Incorrect Number of Rows

>In addition to the trace suggestion, a good one, take a look at the log
>files using Oracle's DBMS_LOGMNR built-in package. If the rows aren't
>showing in the log file (and I'll bet two fingers of a good single malt on
>this one) the problem is definitely elsewhere.
>
>Daniel Morgan

Thanks to both yourself and Niall for the suggestions, I am starting to suspect the software (Omnis7) as I have also had problems recently with a select from DUAL for the next sequence number, ie. in 20000 consecutive inserts it failed once with a row count of zero ... this occurs occasionally even in our test database.

I have some serious investigations to do )

Cheers - Steve
Steve
www.chollie.com
UKMG/MRBPF!C!H?S E4A1 GAS+/-- C= P+ G- B-- R- M= S= r+ Received on Wed Jan 15 2003 - 05:00:52 CST