Re: 0ra-01002 error

spathiyal_at_yahoo.ca wrote:
> Hi there,
> I am getting 0ra-01002 error when I will run the following query.
> Could you please tell me how I can reolve this issue.
>
> Thanks in advance,
> S
>
> select level,id, childid , lpad(' ', 2*level- 1) || childid
> from table
>
> connect by prior childid=id

No Oracle version
Didn't provide the complete error message No DDL so we can we the table structure
No sample data

If you want help please don't post like you are being charged by the character.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)