Re: select (case when .... then ... else ... end) not working in packages?

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Sat, 19 Oct 2002 18:48:00 +0200
Message-ID: <6333rucsvuorjvhkqlml5mkq1up4es3rg6@4ax.com>

On Sat, 19 Oct 2002 16:58:51 +0200, "Raymond" <r_h_at_xs4all.nl> wrote:

>L.s.,
>
>A query with the (case when...) construct doesn't seem
>to work when the query is put inside a procedure in
>a package. Is this a bug, or intended (dis)functionality?
>
>I am using Oracle Server V8.1.6 on OpenVMS.
>
>Regards,
>Raymond.
>

It is a feature. PL/SQL has been lagging behind until Oracle 9i. As 8.1.6 is desupported more than a year ago, you need to upgrade anyway.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sat Oct 19 2002 - 11:48:00 CDT