Problem with decode function with pl/sql cursor in function

From: Nicolas Rancourt <Nicolas.Rancourt_at_videotron.ca>
Date: 1997/07/29
Message-ID: <01bc9c6b$163f1d40$7367fdcf_at_vlewzbwp>#1/1


Hi..

[Quoted] Oracle version 7.1.3.......etc...

I've a problem with the decode function with this context :

select cos.cos_amount,

          decode(cos.cot_code,'LAN',1,'FPR',2,'FPF',3) from cost cos
where cos.cot_code in ('LAN','FPR','FPF') order by 2 desc;

this sqlcode work properly in sql but when I put it on a pl/sql cursor in function,
and when I execute this function, sql return this message

ora-001413 no_data_found...

Anybody have solution for my problem other than put in alphabetic order

thank's

-- 
Nicolas.Rancourt_at_videotron.ca
Groupe Progestic ( www.groupe-progestic.com )
---------------------------------------------------------------------
Conseillers en gestion et en informatique
Bureau	: 514-842-7995
Fax	: 514-842-1602	
Received on Tue Jul 29 1997 - 00:00:00 CEST

Original text of this message