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

Hi Flavio,

seems this is the same bug as 1633710, where exactly the same problem occures with the windowing-functions (sum...over). I am afraid this is not fixed in 8.1.7.

Workarounds: dynamic SQL or creating a view (or 9i ;-)

Hope this helps

Regards
Peter

"FC" <flavio_at_tin.it> wrote in message news:<qXD19.160377$vm5.5380602_at_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 Wed Jul 31 2002 - 11:34:26 CDT