Re: Oracle8 Case expression in PL/SQL

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 7 Oct 2000 12:22:49 +0100
Message-ID: <970918066.11522.2.nnrp-01.9e984b29@news.demon.co.uk>

As usual, the PL/SQL parser is a little behind theSQL parser. You may be able to use the 'execute immediate' work around.

In Oracle 9, this type of inconsistency is supposed to disappear.

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Michael wrote in message <8rjvrc$nj9$1_at_nnrp1.deja.com>...


>I used the new CASE ... WHEN ... THEN ... ELSE ... END statement in an

>insert command. It worked fine in SQL Plus but when I put it into a

>procedure I got an error. I cannot find a reference in the

>documentation. Can somebody confirm that this expression is not

>supported in PL/SQL?

>

>Michael Janos

>Origin Energy

>

>

>Sent via Deja.com http://www.deja.com/

>Before you buy.

Received on Sat Oct 07 2000 - 06:22:49 CDT