set serveroutput on;
declare
  v_lines jh_util.stringlist_t;
  v_values jh_util.stringlist_t;
begin
for rec in (select 1 id, ac.clob_content csv 
FROM PSM_ASSET a INNER JOIN PSM_ASSETCONTENT ac ON ac.asset_id = a.id  
WHERE name = 'teachercommentupload1.txt') loop
    v_lines := jh_util.split(rec.csv, chr(10));
    for i in v_lines.first .. v_lines.last loop
      dbms_output.put_line('line ' || i || ':');
      v_values := jh_util.split(v_lines(i), chr(9)); --Yes, I know this is a tab CHR and not CMA
      /* I will eventually insert the values into the table */
      for j in v_values.first .. v_values.last loop
        dbms_output.put_line('v_values(' || j || ') = ' || v_values(j));
      end loop;
    end loop;
  end loop;
end;

Error report:
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at line 6
06502. 00000 -  "PL/SQL: numeric or value error%s"
*Cause:    
*Action:

set serveroutput on;

CREATE OR REPLACE DIRECTORY DIRECTORY AS 'C:\';

DECLARE
 l_clob CLOB;
BEGIN
  SELECT ac.clob_content INTO l_clob
  FROM PSM_ASSET a
  INNER JOIN PSM_ASSETCONTENT ac ON ac.asset_id = a.id
  WHERE name = 'file.txt';
  
  dpr_clobToFile('file.txt','DIRECTORY',l_clob);
  
END;