71: -- hr_utility.trace('+====c2b===================================================+');
72: dbms_lob.createtemporary(res,TRUE);
73: dbms_lob.open(res,dbms_lob.lob_readwrite);
74: LOOP
75: buffer := utl_raw.cast_to_raw( dbms_lob.substr( c, 16000, pos ) );
76: IF utl_raw.length( buffer ) > 0 THEN
77: dbms_lob.writeappend(res,utl_raw.length(buffer),buffer);
78: END IF;
79: pos := pos + 16000;
72: dbms_lob.createtemporary(res,TRUE);
73: dbms_lob.open(res,dbms_lob.lob_readwrite);
74: LOOP
75: buffer := utl_raw.cast_to_raw( dbms_lob.substr( c, 16000, pos ) );
76: IF utl_raw.length( buffer ) > 0 THEN
77: dbms_lob.writeappend(res,utl_raw.length(buffer),buffer);
78: END IF;
79: pos := pos + 16000;
80: EXIT WHEN pos > lob_len;
73: dbms_lob.open(res,dbms_lob.lob_readwrite);
74: LOOP
75: buffer := utl_raw.cast_to_raw( dbms_lob.substr( c, 16000, pos ) );
76: IF utl_raw.length( buffer ) > 0 THEN
77: dbms_lob.writeappend(res,utl_raw.length(buffer),buffer);
78: END IF;
79: pos := pos + 16000;
80: EXIT WHEN pos > lob_len;
81: END LOOP;