Re: Case statment in Stored Procedure

On 14 Jul 2005 12:20:36 -0700, "reidt2" <reidt2_at_yahoo.com> wrote:

><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

In your program? Likely, but impossible to determine without much more detail.
In Oracle? You do have access to Metastink, don't you?

--
Sybrand Bakker, Senior Oracle DBA