There are number of ways to split comma separated values. This is very simple method to separate the comma separated or any other separated string. you can change the delimiter as per your requirement. This method have a limitation that string can not exceed the 4000 characters.
if you want a functionality more than 4000 characters, Please go for long input values also use packages instead of procedures, because functions do not support long parameter type.
Please comment for any issues/Questions.
How to call function:
The above function returns the pipeline table, you can use a temporary table to insert the values.