Re: PL/SQL problem
From: janet <janet_at_telesph.com>
Date: 1997/03/10
Message-ID: <33244C11.44E_at_telesph.com>#1/1
Date: 1997/03/10
Message-ID: <33244C11.44E_at_telesph.com>#1/1
Stian Hundhammer wrote:
> Can anyone tell me why this :
>
> <snip>
> 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]
quite possibly it has something to do with the two semicolons
in the statement instead of one.
your example which did work, further, only had one semicolon.
remove the semi from the start with clause. janet Received on Mon Mar 10 1997 - 00:00:00 CET