declare 
fns_arr apex_application_global.vc_arr2;
types_arr apex_application_global.vc_arr2;
res varchar2( 500 );
res_1 varchar2( 1000 );

begin
select rep_user into res from tc_users_rep where id_user= 96 ;
types_arr:=apex_util.string_to_table(res);

FOR z IN  1 ..types_arr.count LOOP
htp.p(types_arr(z));
htp.p('<br>');

select tc_rep.file_name into fns_arr from tc_rep where t_rep_id=types_arr(z) and tc_rep.file_name is not null;
END LOOP;
END;

select tc_rep.file_name into fns_arr from tc_rep where t_rep_id=types_arr(z) and tc_rep.file_name is not null;