Re: Using CASE WHEN expression in Package Procedure is not allowed?

Roel Schreurs wrote:
>
> Bricklen <bricklen_at_zyahoo.zcomz> wrote in message news:<Z8e8d.21262$N%.531_at_edtnps84>...
> > Frank van Bortel wrote:
> > <snip>
> > > iirc, case when syntax is not allowed in 8i;
> > > it was introduced in 9iR2...
> >
> > Correct, CASE is allowed in sql, but not in pl/sql in 8i.
>
> Well, that solves the case, then. Thanks for your help.

Alternatively, wrap the statement as dynamic SQL and the PL/SQL can then allow it.

hth

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
ISBN: 1590592174

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com

Coming Soon! "Oracle Insight - Tales of the OakTable"

"GIVE a man a fish and he will eat for a day. But TEACH him how to fish,
and...he will sit in a boat and drink beer all day"

------------------------------------------------------------