Re: "order siblings by" problem with Oracle 9.0.1.1

Hello Vladimir,

"Vladimir M. Zakharychev" <bob_at_dpsp-yes.com> wrote in message news:<b2qua4$94o$1_at_babylon.agtel.net>... ...
> So I think this is a bug in PL/SQL (is was claimed that 9i has
> unified engine used by both SQL and PL/SQL, but apparently
> this was not the case until 9.2).

  Thank you for this information. Slightly modified code works, for example:

declare
 v integer;
 type t_cursor is ref cursor;
 c t_cursor;
begin
 open c for 'select x from (
  select 1 x from dual
 )
 start with x=1
 connect by prior x = x - 1
 order siblings by x';
 fetch c into v;
 dbms_output.put_line ('X is:'||v);
end;
/

  Anyway, I don't like this solution and will migrate to 9.2.

--
Oleg