gistfile1.txt

declare
  l_clob CLOB;
begin  
  for i in 1..20000 loop
    l_clob := l_clob || 'A,B,C,D,E,F,G,H,I' || chr(13);
  end loop;
  
  l_clob := l_clob || 'A,B,C,D,E,F,G,H,I';

  DELETE FROM bra.tmp_csv2;
  DELETE FROM bra.tmp_csv;

  COMMIT;

  INSERT INTO bra.tmp_csv VALUES (l_clob);

  COMMIT;

  tmp_parse_csv(l_clob);

end;
/

SELECT *
  FROM bra.tmp_csv2