declare
  
 v_list varchar2(4000);
begin
   begin
      v_list := :P4_STATES;
      exception when no_data_found then v_list :='0';
   end;
   for y in (select * from(table(DBMS_UTILITY.comma_to_table(:P4_STATES))))
   loop
   INSERT INTO COVIDAPI(STATES_NO) values(y.COLUMN_VALUE);
   end loop;


   for y in (select * from(table(comma_to_table(:P4_POSITIVE))))
   loop
   insert into COVIDAPI(POSITIVE)
   values(y.column_value);
   end loop;
   for y in (select * from(table(comma_to_table(:P4_NEGATIVE))))
   loop
   insert into COVIDAPI(NEGATIVE)
   values(y.column_value);
   end loop;
end;

select * from all_objects where object_name ='COMMA_TO_TABLE'