Using DECODE in stored function

From: Terry Walker <terryw>
Date: 1996/01/18
Message-ID: <4dmdqg$dcd_at_nm3001.router.kraft.com>#1/1


Can anyone tell me why Oracle does not allow us to use the DECODE function inside a stored function?

I get the message: "ORA-1403: No data found" when I try to invoke the function. However, I do not get any compile errors when the function is created. Thanks in advance.

-- 

============================================================================
Terry Walker Internet: terryw_at_kgf.com Kraft Foods twalker_at_kraft.com 250 North Street N1-3 White Plains, NY 10625 (914) 335-4385 Fax - 2015 "I'm not paranoid, everyone IS out to get me!"
============================================================================
Received on Thu Jan 18 1996 - 00:00:00 CET

Original text of this message