PL/SQL problem

PL/SQL problem

[Quoted] 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; 

[Quoted] [Quoted] [Quoted] [Quoted] ... 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