Why not post your actual query? I did a simple test on CASE WHEN in a
packaged procedure with 9i and it worked fine. Sometimes there is a
lag between SQL and PL/SQL parser so one may not understand everything
the other does. You might have hit one of those things. You should be
able to use dynamic SQL to get the job done. Look here for more
discussions
http://shrinkalink.com/432
"Raymond" <r_h_at_xs4all.nl> wrote in message news:<aorrvu$det$1_at_news1.xs4all.nl>...
> 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.
Received on Sat Oct 19 2002 - 14:08:19 CDT
