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