Re: Order by Problem on 8i

> As usual no exact version and no error messages.

The version is 8.1.7 NT where as this works on 9i. The point was to show a reproducable example. The real code is much more complex.

What I do is insert so records into a Temp Table in order then extract them from the temp table doing some other stuff.

The point is why does INSERT INTO ... SELECT ... ORDER BY work when run stand alone but does not compile when placed in a procedure.

I rewrote without the ordder by in the insert and handled it another way. Still wondering if this is a bug or just awkward SQL.

The other post probably hints to my answer that I needn't care about about the order by which is what I did.

Thanks Received on Fri Oct 26 2001 - 02:29:19 CDT