Re: PL/SQL problem
Date: 1997/03/14
Message-ID: <3328bea1.1795702_at_news.teleport.com>#1/1
On Mon, 10 Mar 1997 10:51:51 +0100, Stian Hundhammer <stian_at_origo.no> wrote:
>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]
Might it be the extra semicolon, or did you just make an error when
entering the text? If so, odd that it doesn't give you a message
indicating that it found an order by when it was expecting something
else...
Jonathan Ingram Received on Fri Mar 14 1997 - 00:00:00 CET