Re: Order by Problem on 8i

"tIM" <tjm_at_geac.dk> wrote in message
news:b1f8412c.0110250426.69c05a26_at_posting.google.com...
> Hi I am faced with a problem ...
>
> If I run the following code on Oracle 8i the create procedure fails. I
> can't figure out why because the command alone works!!!
>
> Note that this works on 9i (is this a confirmed bug with a patch or
> anything!!!?!?)
>
> TIA
>
> CREATE TABLE TEST1(
> test1 number(1));
>
> CREATE TABLE TEST2(
> test1 number(1));
>
>
>
> insert into test1 (test1) select test1
> FROM
> test2
> WHERE
> test1='ss'
> ORDER BY test1;
>
> CREATE PROCEDURE TEST
> IS
> BEGIN
> insert into test1 (test1) select test1
> FROM
> test2
> WHERE
> test1='ss'
> ORDER BY test1;
> END;
> /

As usual no exact version and no error messages. As pl/sql is very sensitive to scoping and your column names are identical to your table name this alone is a potential reason why this fails.

Regards

Sybrand Bakker
Senior Oracle DBA

Do Received on Thu Oct 25 2001 - 08:02:27 CDT