SQL & PL/SQL

Hello,
I have a procedure that recieves a string and want to store this string in SYS.ODCIVARCHAR2LIST ();



declare
tes SYS.ODCIVARCHAR2LIST := SYS.ODCIVARCHAR2LIST ();
str varchar2(50);

begin
str:='(''a'',''b'',''c'')';
select * BULK COLLECT INTO tes from (select str from dual);


FOR INDX IN 1 .. tes.COUNT
LOOP
DBMS_OUTPUT.PUT_LINE (tes (indx));
END LOOP;

end;


the output is ('a','b','c')====> the whole string is getting stored in first index of the SYS.ODCIVARCHAR2LIST...I would like to have stored over 3 indexes..

desired output is
a
b
c

Thank you