Re: Using DECODE in stored function

From: Charles Jardine <cj10_at_cam.ac.uk>
Date: 1996/01/25
Message-ID: <4e7sl4$d6p_at_lyra.csx.cam.ac.uk>#1/1


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 certainlyu there in 7.1.4. Received on Thu Jan 25 1996 - 00:00:00 CET

Original text of this message