"order siblings by" problem with Oracle 9.0.1.1

From: Oleg Paraschenko <usenet_at_sein.sportwetten.spb.ru>
Date: 14 Feb 2003 03:52:16 -0800
Message-ID: <70f723dc.0302140352.40ce89dd@posting.google.com>

Hello all,

  I'm using hierarchical query in Oracle 9.0.1.1:

SQL> select x from (
 select 1 x from dual
)
start with x=1
connect by prior x = x -1
order siblings by x;  

         X

---

         1

  But:

SQL> declare

 v integer;                          
begin                       
 select x into v from (
  select 1 x from dual           
 )
 start with x=1           

 connect by prior x = x - 1
 order siblings by x;
 dbms_output.put_line ('X is:'||v);

end;     
/        

ERROR at line 9:
ORA-06550: line 9, column 8:
PL/SQL: ORA-30929: ORDER SIBLINGS BY clause not allowed here ORA-06550: line 4, column 2:
PL/SQL: SQL Statement ignored

  Is it some problem with my SQL or is it problem with Oracle?

Regards, Oleg Received on Fri Feb 14 2003 - 05:52:16 CST