Re: Function that Iterates down a structure

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Sat, 12 Mar 2005 19:23:07 -0800
Message-ID: <1110683990.177638@yasure>

DA Morgan wrote:

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

Sorry for pressing the SEND button a bit prematurely. Should have been:

"Is ID a string?

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

Received on Sat Mar 12 2005 - 21:23:07 CST