Case statements in PL/SQL

[Guest]

hi,

Can I have select query with case statement in Package

Wheni run the sql query with case in normal sql editor its returning me results but when i try to add the query in Package and try to compile the [ackage its throwing error near case statement

Regards,
Smita

[Guest]

Pls see http://www.oracle-base.com/articles/9i/case-expressions-and-statements-9i.php

It clearly says "The CASE expression was first added to SQL in Oracle8i. Oracle9i extends its support to PL/SQL to allow CASE to be used as an expression or statement"

[Guest]

Check http://www.tek-tips.com/viewthread.cfm?qid=662052

[Guest]

You can either rewrite your query to use decode or use dynamic sql. If you use dynamic sql, then it uses the sql engine where case was available in 8i, instead of the pl/sql engine, where case was not available.