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
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-1602Received on Tue Jul 29 1997 - 00:00:00 CEST