491:
492: DBMS_LOB.CREATETEMPORARY(v_clob, TRUE);
493:
494: FOR i IN 1..CEIL(DBMS_LOB.GETLENGTH(p_text_in_word) / v_buffer) LOOP
495: v_varchar := UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(p_text_in_word, v_buffer, v_start));
496: DBMS_LOB.WRITEAPPEND(v_clob, LENGTH(v_varchar), v_varchar);
497: v_start := v_start + v_buffer;
498: END LOOP;
499:
844:
845: DBMS_LOB.CREATETEMPORARY(v_clob, TRUE);
846:
847: FOR i IN 1..CEIL(DBMS_LOB.GETLENGTH(p_text_in_word) / v_buffer) LOOP
848: v_varchar := UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(p_text_in_word, v_buffer, v_start));
849: DBMS_LOB.WRITEAPPEND(v_clob, LENGTH(v_varchar), v_varchar);
850: v_start := v_start + v_buffer;
851: END LOOP;
852: