944: END IF;
945: --
946: DBMS_LOB.READ(p_clob,l_chunk_len,l_offset,l_varchar_buffer);
947: --
948: l_raw_buffer := utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.AL32UTF8',g_nls_db_char);
949: l_raw_buffer_len := utl_raw.length(utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.AL32UTF8',g_nls_db_char));
950: dbms_lob.write(p_blob,l_raw_buffer_len, l_blob_offset, l_raw_buffer);
951: --
952: l_blob_offset := l_blob_offset + l_raw_buffer_len;
945: --
946: DBMS_LOB.READ(p_clob,l_chunk_len,l_offset,l_varchar_buffer);
947: --
948: l_raw_buffer := utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.AL32UTF8',g_nls_db_char);
949: l_raw_buffer_len := utl_raw.length(utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.AL32UTF8',g_nls_db_char));
950: dbms_lob.write(p_blob,l_raw_buffer_len, l_blob_offset, l_raw_buffer);
951: --
952: l_blob_offset := l_blob_offset + l_raw_buffer_len;
953: l_offset := l_offset + l_chunk_len;