SET SERVEROUTPUT ON
DECLARE
  l_list1   VARCHAR2(50) := 'A,B,C,D,E,F,G,H,I,J';
  l_list2   VARCHAR2(50);
  l_tablen  BINARY_INTEGER;
  l_tab     DBMS_UTILITY.uncl_array;
BEGIN
  DBMS_OUTPUT.put_line('l_list1 : ' || l_list1);

  DBMS_UTILITY.comma_to_table (
     list   => l_list1,
     tablen => l_tablen,
     tab    => l_tab);

  FOR i IN 1 .. l_tablen LOOP
    DBMS_OUTPUT.put_line(i || ' : ' || l_tab(i));
  END LOOP;

  DBMS_UTILITY.table_to_comma (
     tab    => l_tab,
     tablen => l_tablen,
     list   => l_list2);

  DBMS_OUTPUT.put_line('l_list2 : ' || l_list2);
END;
/

SQL> SET SERVEROUTPUT ON
SQL> DECLARE
  2    l_list1   VARCHAR2(50) := 'AAA,BBB,CCC , DDD';
  3    l_tablen  BINARY_INTEGER;
  4    l_tab     DBMS_UTILITY.uncl_array;
  5  BEGIN
  6    DBMS_OUTPUT.put_line('l_list1 : ' || l_list1);
  7
  8    DBMS_UTILITY.comma_to_table (
  9       list   => l_list1,
 10       tablen => l_tablen,
 11       tab    => l_tab);
 12  END;
 13  /
l_list1 : AAA,BBB,CCC , DDD

PL/SQL procedure successfully completed.

SQL> DECLARE
  2    l_list1   VARCHAR2(50) := '1,2,3BB';
  3    l_tablen  BINARY_INTEGER;
  4    l_tab     DBMS_UTILITY.uncl_array;
  5  BEGIN
  6    DBMS_OUTPUT.put_line('l_list1 : ' || l_list1);
  7
  8    DBMS_UTILITY.comma_to_table (
  9       list   => l_list1,
 10       tablen => l_tablen,
 11       tab    => l_tab);
 12  END;
 13  /
l_list1 : 1,2,3BB
DECLARE
*
ERROR at line 1:
ORA-00931: missing identifier
ORA-06512: at "SYS.DBMS_UTILITY", line 125
ORA-06512: at "SYS.DBMS_UTILITY", line 160
ORA-06512: at "SYS.DBMS_UTILITY", line 202
ORA-06512: at line 8


SQL> DECLARE
  2    l_list1   VARCHAR2(50) := 'create,table,for';
  3    l_tablen  BINARY_INTEGER;
  4    l_tab     DBMS_UTILITY.uncl_array;
  5  BEGIN
  6    DBMS_OUTPUT.put_line('l_list1 : ' || l_list1);
  7
  8    DBMS_UTILITY.comma_to_table (
  9       list   => l_list1,
 10       tablen => l_tablen,
 11       tab    => l_tab);
 12  END;
 13  /
l_list1 : create,table,for
DECLARE
*
ERROR at line 1:
ORA-00931: missing identifier
ORA-06512: at "SYS.DBMS_UTILITY", line 125
ORA-06512: at "SYS.DBMS_UTILITY", line 160
ORA-06512: at "SYS.DBMS_UTILITY", line 202
ORA-06512: at line 8


SQL>

SQL> ed
Wrote file afiedt.buf

  1  Create or replace function STRING_TO_TABLE(pi_string in varchar2)
  2  Return varchar2
  3  is
  4    l_tablen  BINARY_INTEGER;
  5    l_tab     DBMS_UTILITY.uncl_array;
  6  BEGIN
  7    DBMS_UTILITY.comma_to_table (
  8       list   => pi_string,
  9       tablen => l_tablen,
 10       tab    => l_tab);
 11    FOR i IN 1 .. l_tablen LOOP
 12      l_tab(i) := pi_string;
 13    END LOOP;
 14* END STRING_TO_TABLE ;
SQL> /

Function created.




SQL> ed
Wrote file afiedt.buf

  1  create table x1
  2  (
  3  value varchar2(200)
  4* )
  5  /

Table created.

SQL> insert into x1 values('&value');
Enter value for value: 32,36,12,65,85,9663


1 row created.

SQL> /
Enter value for value: 43,36,89,65,112,9663


1 row created.

SQL> /
Enter value for value: 36,63,12,65,95,123


1 row created.


SQL> /
Enter value for value: 32,36,12,85, 85,9663

1 row created.

SQL> select * from x1;

VALUE                                                           
----------------------------------------------
32,36,12,65,85,9663 
43,36,89,65,112,9663
36,63,12,65,95,123
32,36,12,85, 85,9663


SQL> select STRING_TO_TABLE(value) from x1;
select STRING_TO_TABLE(value) from x1
       *
ERROR at line 1:
ORA-00931: missing identifier 
ORA-06512: at "SYS.DBMS_UTILITY", line 125 
ORA-06512: at "SYS.DBMS_UTILITY", line 160 
ORA-06512: at "SYS.DBMS_UTILITY", line 202 
ORA-06512: at "SCOTT.STRING_TO_TABLE", line 7