Re: Order by Problem on 8i

There are some obscure glitchy differences between SQL and PL/SQL syntax pre-9i. For 9i this was cleaned up.

John

On 26 Oct 2001 00:29:19 -0700, tjm_at_geac.dk (tIM) wrote:

>> 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

--
Got an Oracle database question?
Try the search engine for the database docs at:
http://tahiti.oracle.com/