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 -> Re: PL/SQL does not recognize CASE WHEN ELSE END construct as a valid expression

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

From: FC <flavio_at_tin.it>
Date: Wed, 31 Jul 2002 19:14:55 GMT
Message-ID: <PGW19.166129$vm5.5503778@news2.tin.it> 





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
Received on Wed Jul 31 2002 - 14:14:55 CDT












Original text of this message













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