parsing string in stored procedure.
271944Apr 21 2005 — edited Apr 26 2005I have a list of numbers that is passed from java class like this.
1,2,3,4,5,6,7,8,9,10
these numbers are generated dynamically in java class file. sometimes it might pass 2,3,4.
So I want to match these number to one of the columns in "IN" clause like this. this query is inside the stored procedure.
select * from table where group_id in (....).
but the problem is that the data type of the group_id is number. that's why I got "Invalid number" when I execute this stored procedure. is there any way to do it or any tutorial that I can look up?
Thanks.