Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Case statment in Stored Procedure

Case statment in Stored Procedure

From: reidt2 <reidt2_at_yahoo.com>
Date: 14 Jul 2005 12:20:36 -0700
Message-ID: <1121368836.038161.194170@z14g2000cwz.googlegroups.com> 





<Not sure if this got posted so am trying again> I am having a problem
with a stored procedure where I am inserting values selected from
another table and am using a case statement
(case--when--then--else--end) on the select.  oracle 10g, 9i and 8i all
evaluate the case stament to null. My workaround is to create a view
with the case statement and select from the view.  Is this a bug?
Thanks!


Tim
Received on Thu Jul 14 2005 - 14:20:36 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US