7 Replies Latest reply: Jul 24, 2013 2:30 PM by sreese RSS

    How to use NVL function for a parameter with comma delimited values

    sreese

      Gurus,

       

      This one is baffling me.  I'm trying to use the NVL function but the parameter I'm passing into my  cursor contains multiple comma delimited values.  The NVL function is getting confused when analyzing the values.

       

      "Where" clause in cursor...

      and nvl(sn.c_attribute1,'x@#$%') in nvl(p_desig,'x@#$%')

       

      parameter translated values...

      and nvl(sn.c_attribute1,'x@#$%') in nvl('SPRT','GOOD','BAD','x@#$%') -- NVL not analyzing the alternative value properly

       

       

      Any idea on how to get NVL to recognize 'x@#$%' if p_desig is null?

       

       

      Thanks

      Scott