A list of comma separated values is a common quick way to pass an array. There are many ways to split it too, the simplest being a recursive CTE. how to pass an array to an oracle stored procedure should find an array of solutions.