Passing in Comma Separated List to Stored Proc Input Param

[jmeyer32]

I have a Stored Procedure in Oracle that accepts a VARCHAR input parameter - I_LIST IN VARCHAR. The value will be a comma separated list "1,2,3".

The SQL statement in the proc is select * from table where id in (I_LIST);

No results are returned. When I just pass in one value it works fine but more then one and I get no results. Any thoughts? Thanks!!