Here is an alternate way to get a comma (or any other character) separated list of values that comes from rows in a table. This solution is based on hierarchical queries.
select myvalues, row_number() over (order by myvalues) rn, count(*) over () cnt
select VC_EMAILADDESS myvalues from PERM_EXTRACTS.TBL_EMAIL_ADDRESSES
select ltrim(sys_connect_by_path(myvalues, ','),',') catvalues
where rn = cnt
start with rn = 1
connect by prior rn = rn-1;
P_VC_TO = dannnie.moodie@XXXXX.net,dannnie.moodie@XXXXX.com