APEX

Hi all,

I posted this question in the PL/SQL forum (776947 but as Justin replied, there may be a solution in APEX so I wanted to ask here as well.

----------

I have a procedure that looks like the one below and I'm sending the IN parameters from an Apex screen.

procedure getData (p_param1 in varchar2, p_param2 in varchar2)
is
begin


for x in (select col1, 
              from table
              where colx = param1
              and coly in (param2)
              )
              
....

end;

This works fine until the user chooses more than one value on the Apex page (it's a multiselect list box). The values are passed into the procedure in a colon delimited list, so it looks like

VALUE1:VALUE2:VALUE3

My question is, how can I parse out the values so that the where clause looks like,

...
where colx = param1
and coly in ('VALUE1','VALUE2')
...

or something like that?


Thanks for any help.

-Chris