Oracle CASE

From: Mtek <mtek_at_mtekusa.com>
Date: Mon, 23 Feb 2009 10:30:45 -0800 (PST)
Message-ID: <0d444206-9e41-4867-a3e9-459e0207ea14_at_l1g2000yqj.googlegroups.com>


[Quoted] Can you have multiple conditions in the WHEN clause of a CASE statement?

   CASE v_subproduct_id
   WHEN 197 OR 95 THEN
.
.
.

I get some weird stuff:

LINE/COL ERROR



45/4     PL/SQL: Statement ignored
46/9     PLS-00382: expression is of wrong type
Received on Mon Feb 23 2009 - 19:30:45 CET

Original text of this message