Comma seperated strin

Hi,

The query of a procedure is using IN clause to validate a parameter as below. In some scenarios to the parameter multiple values will have to be passed.

Can anyone please let me know how to pass string seprated values to IN clause

Query:

select *

from A

Where col1 in (:p_col1)

Parameter values:

p_col1 :=  1

p_col1 := 1,2,3 (if multiple values are being passed like this , query returns now rows).