Re: Oracle CASE statement precompile error in Micro Focus

JCE -

Thanks for the quick reply.

Unfortunately this was just a simple example for posting. The actual
CASE statement is buried in a subquery of a more complex query. Having
the CASE statement there meant I only needed one cursor where the
alternative is two cursors with the additional OPEN, FETCH and CLOSE
statements.

On a side note, Oracle manuals discuss CASE alongside DECODE. It
appears that DECODE can do all the things a CASE statement can but with
more complexity and less readability than the CASE statement. I
converted the CASE to a DECODE and the compile worked. Now its a
matter of testing the change, but I would still prefer the CASE...

.