Hello,
we are having a particular problem with the DBMS_UTILITY.COMMA_TO_TABLE function.
The PLSQL code is as follows:
DECLARE
l_input varchar2(50) := 'S.,PIETRO,IN,VINCOLI';
l_count binary_integer;
l_array dbms_utility.lname_array;
begin
dbms_utility.comma_to_table(l_input, l_count, l_array);
IF l_count > 0 then
FOR i IN 1 .. l_count
LOOP
dbms_output.put_line(l_array(i));
END LOOP;
END IF;
EXCEPTION
WHEN others THEN
dbms_output.put_line('errore = '||sqlerrm);
END;
It seems that when the "IN" piece is present, the function returns errore = ORA-20001: comma-separated list invalid near I
How can we solve this?
Thank you.