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

Yep. the bug is corrected in 9i. As seen, Raymond is running 8.1.6......

• Kenneth Koenraadt

On 19 Oct 2002 12:08:19 -0700, JusungYang_at_yahoo.com (Jusung Yang) wrote:

>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
>
>
>- Jusung Yang
>
>
>"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 Sun Oct 20 2002 - 04:45:45 CDT