Rainer Herbst wrote:
>
> really interesting code. You loop 10 times over the same sql statement?
> You expect to see ten times the same output? I guess you should check
> the logic once again.
>
> As I understand, you run this code on two different databases. The
> statement does not contain some ORDER BY clause, so the order of the
> returned values is very mucht to be different on different databases,
> even on databases of the same version. Have you tried to run the code
> on two 9i databases? Or on two 8i databases?
>
> Regards!
> Rainer
>
> --
> ------------------------------------------------
> Rainer Herbst Linux - Registered
> ZEIK User #319157
> Universität Potsdam Usual disclaimers applies!
> ------------------------------------------------
Yes, the code runs on two different versions of Oracle. There is no
order by clause, since I don't need one for what I am doing with the
data (making a pie graph, to be exact). The loop is similar to what
happens in the real code (which is about 3x as long). I made this
example so that others could run it on their vanilla systems without
modification, to see what I see. I'm not worried about the somewhat
pointless loop etc in this sample code.
Received on Thu Aug 28 2003 - 08:53:49 CDT
