CREATE OR REPLACE PROCEDURE ( v_scalar_in IN VARCHAR) AS 

      here you have to substr with the index of "," and then send it in for loop for your processing