Re: CASE strucrure in PL/SQL

CASE in an assignment is valid in 8i. My example was in an 8i instance. You just have to have the syntax right.

Originally posted by Vladimir M. Zakharychev
> "Jaap W. van Dijk" wrote in message
> news:n2gsdv81e7162v0h3fkn5qekb0vq6qmgs1_at_4ax.com"]news:n2gsdv81e-
> 7162v0h3fkn5qekb0vq6qmgs1_at_4ax.com[/url]...
>
> SQL and PL/SQL are two different beasts, so quoting SQL Reference
> for PL/SQL question is not correct, even though they share the same
> SQL engine in 9i. PL/SQL User's Guide and Reference has its own
> section on CASE and that assignment statement is pretty valid, just
> not in 8i, which was OP's source of the problem.
>
> --
> Vladimir Zakharychev (bob_at_dpsp-yes.com) http://w-
> ww.dpsp-yes.com/http://www.dpsp-yes.com
> Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet
> applications.

All opinions are mine and do not necessarily go in line with those of my employer.

--
Posted via http://dbforums.com