Re: Using DECODE in stored function
From: Stuart Hemming <shemminga_at_cix.compulink.co.uk>
Date: 1996/01/22
Message-ID: <DLLAHB.5yu_at_cix.compulink.co.uk>#1/1
These are *my* opinions. Please don't make the mistake of believing anybody else is stupid enough to think like this!
Date: 1996/01/22
Message-ID: <DLLAHB.5yu_at_cix.compulink.co.uk>#1/1
If you're trying to use it in a PL/SQL statement rather than an SQL statement it won't work. However, I think you could fudge it by using
SELECT <your decode function> into <variable> from dual;
These are *my* opinions. Please don't make the mistake of believing anybody else is stupid enough to think like this!
Stuart Hemming | shemminga_at_cix.compulink.co.uk The Data Base | Tel: + 44 (0) 115 925 0005 Nottingham UK | Fax: + 44 (0) 115 929 4668Received on Mon Jan 22 1996 - 00:00:00 CET
-------------------------------------------------------------------