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: select (case when .... then ... else ... end) not working in packages?

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

From: <kenneth.koenraadt_at_no-spam.hotmail.com>
Date: Sat, 19 Oct 2002 17:02:23 GMT
Message-ID: <3db18fcc.213937@news.mobilixnet.dk>


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's a bug. The workaround is to rewrite the query in dynamic SQL.

Received on Sat Oct 19 2002 - 12:02:23 CDT

Original text of this message

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