Re: Function that Iterates down a structure

mike wrote:

> Michel,
>
> Cool, my qry:
>
> SELECT struct_id, par_struct_id, chd_struct_id, struct_level
> FROM struct
> START WITH chd_struct_id='4'
> CONNECT BY PRIOR chd_struct_id=par_struct_id
> ORDER SIBLINGS BY struct_level
>
> produced the error "ORA-00924: missing BY keyword"
>
> If I take off the Order by line it works fine, but it is not ordered.
>
> Documentation shows that I can do this successfully.
>
> See anything wrong?
>
> Mike

Possibly. Is a string? If it is change it to a NUMBER. If it isn't change your DML.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)