replace length with dbms_lob.getlength
replace length with dbms_lob.getlength

Length operations on clob using standard length caused issues when emoji/extended unicode characters were present.
OraOpenSource/apex-plugin-clob-load