Re: Using DECODE in stored function

Michael Marsden (MMARSDEN_at_NITGNET1.telecom.com.au) wrote:
:
: Well, according to my PL/SQL Users Guide and Reference (v2.0),
: decode is a standard 'built-in' function. (Refer page 2-59).
:
: You certainly may use decode within stored functions and procedures.
:

If you read VERY carefully you will see it also says "DECODE IS ALLOWED ONLY IN SQL STATEMENTS". It cannot be used in a procedural statement. That is, I don't believe you could do:

x := decode(abc,xyz,123);

Tony Damon Received on Thu Jan 25 1996 - 00:00:00 CET