Re: PL/SQL problem

MarkP28665 wrote:
>
> Shouldn't the start with clause be place before the connect by clause?
> Maybe that is the problem.
>
> >cursor c_cce(b_cce_id in spa_catalogues_categories.id%type) is
> > select level
> > , cce.id
> > , cce.cce_id
> > , cce.cae_id
> > from spa_catalogues_categories cce
> > connect by prior cce.cce_id = cce.id
> > start with cce.id = b_cce_id;
> > order by level desc;
> >
> >
> >... is giving me :
> >
> >
> >
> >
> >LINE/COL ERROR
> >-------- ----------------------------------
> >0/0 PLS-00801: internal error [74303]
>
> Trying to help.
>
> Mark Powell -- The only advise that counts is the advise that you follow
> so follow your own advise
 This error you can escape by removing ORDER BY LEVEL clause from select statement. Received on Thu Mar 20 1997 - 00:00:00 CET