Please check DBMS_UTILITY.COMMA_TO_TABLE - this allows you to parse comma delimited list of parameters into a pl/sql table.