914: raw_data RAW(32767);
915: temp_blob BLOB;
916: BEGIN
917:
918: raw_data:=utl_raw.cast_to_raw(p_text);
919: text_size:=utl_raw.length(raw_data);
920:
921: dbms_lob.createtemporary(temp_blob,false,DBMS_LOB.CALL);
922: dbms_lob.open(temp_blob,dbms_lob.lob_readwrite);
915: temp_blob BLOB;
916: BEGIN
917:
918: raw_data:=utl_raw.cast_to_raw(p_text);
919: text_size:=utl_raw.length(raw_data);
920:
921: dbms_lob.createtemporary(temp_blob,false,DBMS_LOB.CALL);
922: dbms_lob.open(temp_blob,dbms_lob.lob_readwrite);
923:
2748: dbms_lob.createtemporary(l_xml_blob,false,DBMS_LOB.CALL);
2749: dbms_lob.open(l_xml_blob,dbms_lob.lob_readwrite);
2750: hr_utility.trace('OPENED l_xml_blob ' );
2751:
2752: raw_data:=utl_raw.cast_to_raw(l_xml_string);
2753: text_size:=utl_raw.length(raw_data);
2754:
2755: dbms_lob.writeappend(l_xml_blob,text_size,raw_data);
2756:
2749: dbms_lob.open(l_xml_blob,dbms_lob.lob_readwrite);
2750: hr_utility.trace('OPENED l_xml_blob ' );
2751:
2752: raw_data:=utl_raw.cast_to_raw(l_xml_string);
2753: text_size:=utl_raw.length(raw_data);
2754:
2755: dbms_lob.writeappend(l_xml_blob,text_size,raw_data);
2756:
2757: hr_utility.trace('Get Length l_xml_clob ' ||dbms_lob.getlength(l_xml_blob) );
3708:
3709: dbms_lob.createtemporary(l_temp_blob,false,DBMS_LOB.CALL);
3710: dbms_lob.open(l_temp_blob,dbms_lob.lob_readwrite);
3711:
3712: raw_data:=utl_raw.cast_to_raw(l_final_xml_string);
3713: text_size:=utl_raw.length(raw_data);
3714:
3715: -- dbms_lob.writeappend(l_final_xml,text_size,raw_data);
3716:
3709: dbms_lob.createtemporary(l_temp_blob,false,DBMS_LOB.CALL);
3710: dbms_lob.open(l_temp_blob,dbms_lob.lob_readwrite);
3711:
3712: raw_data:=utl_raw.cast_to_raw(l_final_xml_string);
3713: text_size:=utl_raw.length(raw_data);
3714:
3715: -- dbms_lob.writeappend(l_final_xml,text_size,raw_data);
3716:
3717: /*dbms_lob.writeappend(l_final_xml,
3714:
3715: -- dbms_lob.writeappend(l_final_xml,text_size,raw_data);
3716:
3717: /*dbms_lob.writeappend(l_final_xml,
3718: utl_raw.length(utl_raw.cast_to_raw(l_final_xml_string)),
3719: utl_raw.cast_to_raw(l_final_xml_string)
3720: );*/
3721: l_temp_blob := append_to_lob(l_final_xml_string);
3722: dbms_lob.append(l_final_xml,l_temp_blob);
3715: -- dbms_lob.writeappend(l_final_xml,text_size,raw_data);
3716:
3717: /*dbms_lob.writeappend(l_final_xml,
3718: utl_raw.length(utl_raw.cast_to_raw(l_final_xml_string)),
3719: utl_raw.cast_to_raw(l_final_xml_string)
3720: );*/
3721: l_temp_blob := append_to_lob(l_final_xml_string);
3722: dbms_lob.append(l_final_xml,l_temp_blob);
3723:
3726: hr_utility.trace('Get Length l_final_xml ' ||dbms_lob.getlength(l_final_xml) );
3727:
3728: dbms_lob.append(l_final_xml,lc_emp_blob);
3729:
3730: raw_data:=utl_raw.cast_to_raw(l_last_xml_string);
3731: text_size:=utl_raw.length(raw_data);
3732:
3733: --dbms_lob.writeappend(l_final_xml,text_size,raw_data);
3734:
3727:
3728: dbms_lob.append(l_final_xml,lc_emp_blob);
3729:
3730: raw_data:=utl_raw.cast_to_raw(l_last_xml_string);
3731: text_size:=utl_raw.length(raw_data);
3732:
3733: --dbms_lob.writeappend(l_final_xml,text_size,raw_data);
3734:
3735: /*dbms_lob.writeappend(l_final_xml,
3732:
3733: --dbms_lob.writeappend(l_final_xml,text_size,raw_data);
3734:
3735: /*dbms_lob.writeappend(l_final_xml,
3736: utl_raw.length(utl_raw.cast_to_raw(l_last_xml_string)),
3737: utl_raw.cast_to_raw(l_last_xml_string)
3738: );*/
3739:
3740:
3733: --dbms_lob.writeappend(l_final_xml,text_size,raw_data);
3734:
3735: /*dbms_lob.writeappend(l_final_xml,
3736: utl_raw.length(utl_raw.cast_to_raw(l_last_xml_string)),
3737: utl_raw.cast_to_raw(l_last_xml_string)
3738: );*/
3739:
3740:
3741: l_temp_blob := append_to_lob(l_last_xml_string);