Re: PL/SQL problem

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 Received on Thu Mar 13 1997 - 00:00:00 CET