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

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

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Wed, 31 Jul 2002 20:43:49 GMT
Message-ID: <3D484C03.1B590384@exesolutions.com>

FC wrote:

> Thanks for the feedback ladies and gentlemen,
> I translated the query into a decode statement, less readable but it works.
>
> I found several amusing parser problems with object-relational stuff as well
> (varrays, nested tables of objects and alike), took a while to get around
> them, but it's somewhat exciting to find a way to overcome such annoying
> errors.
>
> Bye,
> Flavio

As I posted yesterday or the day before. CASE works just fine in 8i. It just needs to be wrapped in dynamic sql.

Daniel Morgan Received on Wed Jul 31 2002 - 15:43:49 CDT