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

From: M Hashim <m.a.n.hashim_at_sympatico.ca>
Date: Sun, 20 Oct 2002 00:11:29 -0700
Message-ID: <N_ps9.4219$OG5.860514@news20.bellglobal.com>

<kenneth.koenraadt_at_no-spam.hotmail.com> wrote in message news:3db18fcc.213937_at_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.
True..Did the workaround, and it works fine. Your choice,

Execute immediate
or

DBMS_SQL
>
>
> - Kenneth Koenraadt
Received on Sun Oct 20 2002 - 02:11:29 CDT