Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: select (case when .... then ... else ... end) not working in packages?
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.