Originally posted by kanna may i know why we can't use CASE in 8.1.0.6?
You can use it in sql.
Not in pl/sql becuse Oracle did not implement it in pl/sql engine.
You can use decode or dynamic sql from within pl/sql block as a workaround.
Tomaž "A common mistake that people make when trying to design something completely
foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams