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


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 4668

-------------------------------------------------------------------
Received on Mon Jan 22 1996 - 00:00:00 CET

Original text of this message