title: how to club multiple cases with OR in case statement in plsql
body: <p>i have a case statement in plsql ,
  and the thing is for more than one case i am calling same procedure , so don't want to call the same function again and again and want to club the cases together which call same procedure.</p>
  
  <pre><code>LOOP                                                                         
  FETCH cu_my_cur INTO lr_my_rec;                                                 
  EXIT WHEN cu_my_cur%NOTFOUND;
  
  CASE lr_my_rec.method_name
      WHEN 'ProductName' THEN
           -- population record with product name , product version and product type
           p_required_det(pn_product_reference =&gt; pr_mi_exits.policy_reference
                         ,pv_product_name      =&gt; pr_out_rec.product_name
                         ,pn_product_version   =&gt; pr_out_rec.product_version
                         ,pv_product_type      =&gt; pr_out_rec.product_type);
  
      WHEN 'ProductVersion' THEN
           -- population record with product name , product version and product type
           p_required_det(pn_product_reference =&gt; pr_mi_exits.policy_reference
                         ,pv_product_name      =&gt; pr_out_rec.product_name
                         ,pn_product_version   =&gt; pr_out_rec.product_version
                         ,pv_product_type      =&gt; pr_out_rec.product_type);
      WHEN 'ProductType' THEN 
           -- population record with product name , product version and product type
           p_required_det(pn_product_reference =&gt; pr_mi_exits.policy_reference
                         ,pv_product_name      =&gt; pr_out_rec.product_name
                         ,pn_product_version   =&gt; pr_out_rec.product_version
                         ,pv_product_type      =&gt; pr_out_rec.product_type);
      ELSE              
          NULL;
  END CASE;                    
  </code></pre>
  
  <p>END LOOP;</p>
  
  <p>I want something like this , </p>
  
  <pre><code>CASE lr_my_rec.method_name 
  
  
  WHEN 'ProductName' OR 'ProductVersion' OR 'ProductType' THEN 
    -- population record with product name , product version and product type
           p_required_det(pn_product_reference =&gt; pr_mi_exits.policy_reference
                         ,pv_product_name      =&gt; pr_out_rec.product_name
                         ,pn_product_version   =&gt; pr_out_rec.product_version
                         ,pv_product_type      =&gt; pr_out_rec.product_type);
  ELSE 
   NULL;
  END CASE;
  </code></pre>
  
  <p>But when trying getting error . </p>
  
  <p>Expression is of wrong type.</p>
  
  <p>can you guys please help me to get it done. 
  note : I have to use switch only.
  cant use IF ELSE things.</p>