Three ways to avoid Case Not Found errors in PL/SQL
May 2, 2007[From Builder.com]
PL/SQL has a rich CASE functionality. The selector CASE statement lets you test the value of an expression (much as the DECODE function does), and it also lets you execute one or more statements for the first matching value. The searched CASE statement lets you test multiple expressions and execute one or more statements based on the first expression that is found to be true.
The article continues at http://builder.com.com/5100-6388_14-6180606.html?tag=sc