Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> PL/SQL does not recognize CASE WHEN ELSE END construct as a valid expression

PL/SQL does not recognize CASE WHEN ELSE END construct as a valid expression

From: FC <flavio_at_tin.it>
Date: Tue, 30 Jul 2002 21:55:34 GMT
Message-ID: <qXD19.160377$vm5.5380602@news2.tin.it>


Hello,
did anybody come across the following on Win2K Ora 8.1.7.0.0 EE?

While I am allowed to use the CASE WHEN ELSE END construct within ordinary SQL, I cannot use it within PL/SQL modules (syntax error occurs). On the other hand I can use the DECODE function, although it's harder to code in certain cases.
I couldn't find any document stating that PL/SQL does not support this feature.

Bye...
Flavio Received on Tue Jul 30 2002 - 16:55:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US