Passing multiples value to a parameter

[ekta22]

Hi,

I am using Crystal Reports to pass multiple value to my parameter(pSTATUS) declared in my oracle package.

Field for this parameter can accept upto three values..'O', 'X' and 'V'. The way it will be passed from Crystal to Oracle is in the following format depending on how many values a user selects.

O,X
O,X,V
O

I tried using the IN clause in my where statement but it does not work. I see all the values even if I select just one. How should I handle this in Oracle. I am using 10g.

Thanks in advance,

-E

 

[Dagon]

You mean you are trying to do something like:

select x,y,z
from table
where column in p_parameter

That will not work. The only way to do this is to use dynamic SQL e.g.

v_sql := 'select x,y,z
from table
where column in ('||p_parameter||')';

open cursor for v_sql;
...