Re: Using DECODE in stored function
Date: 1996/01/27
Message-ID: <4ecckt$cpc_at_inet-nntp-gw-1.us.oracle.com>#1/1
Charles Jardine <cj10_at_cam.ac.uk> writes:
|> Terry Walker <terryw> wrote:
|> >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.
|> >--
|>
|> I have been poking about on the shiny new Support CD. This is described
|> in PCR No: 240820. It is said there to be a bug, but no bug number is
|> quoted. I would be interested to know if it is fixed in 7.2. It is
|> certainly there in 7.1.4.
|>
|>
I filed that bug. As far as I can tell, it is fixed in 7.1.6 (though the
base bug it refers to says it was fixed slightly earlier in PL/SQL Version
2.1.5).
Roderick Manalac
Oracle Corporation
Received on Sat Jan 27 1996 - 00:00:00 CET