Re: PL/SQL problem

This appears to be a genuine bug (as opposed to "feature") and should therefore be reported as such, like most internal errors (giving a translated dump, if possible)

You don't say what your environment is, but I was able to reproduce this behaviour exactly under V7.1.6 on a Mac PowerBook.

Interestingly, the procedure works (and gives expected results) if you *either* remove the <order by level> clause *or* remove <level> from the select list!

Chrysalis.

Stian Hundhammer wrote:
>
> PL/SQL problem
>
> Can anyone tell me why this :
>
> 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]
>
> ....while this dosn't :
>
> 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 there no way to order the result by level? I've tried to do this
> select in sqlPlus, and it seems to be ok.
>
> Thanks for your help in advance.
>
> Stian
>
> stian_at_origo.no
Received on Mon Mar 10 1997 - 00:00:00 CET