23: raw_data RAW(32767);
24: temp_blob BLOB;
25: BEGIN
26:
27: raw_data:=utl_raw.cast_to_raw(p_text);
28: text_size:=utl_raw.length(raw_data);
29:
30: dbms_lob.createtemporary(temp_blob,false,DBMS_LOB.CALL);
31: dbms_lob.open(temp_blob,dbms_lob.lob_readwrite);
24: temp_blob BLOB;
25: BEGIN
26:
27: raw_data:=utl_raw.cast_to_raw(p_text);
28: text_size:=utl_raw.length(raw_data);
29:
30: dbms_lob.createtemporary(temp_blob,false,DBMS_LOB.CALL);
31: dbms_lob.open(temp_blob,dbms_lob.lob_readwrite);
32:
1273: dbms_lob.createtemporary(l_xml_blob,false,DBMS_LOB.CALL);
1274: dbms_lob.open(l_xml_blob,dbms_lob.lob_readwrite);
1275: hr_utility.trace('OPENED l_xml_blob ' );
1276:
1277: raw_data:=utl_raw.cast_to_raw(l_xml_string);
1278: text_size:=utl_raw.length(raw_data);
1279:
1280: dbms_lob.writeappend(l_xml_blob,text_size,raw_data);
1281:
1274: dbms_lob.open(l_xml_blob,dbms_lob.lob_readwrite);
1275: hr_utility.trace('OPENED l_xml_blob ' );
1276:
1277: raw_data:=utl_raw.cast_to_raw(l_xml_string);
1278: text_size:=utl_raw.length(raw_data);
1279:
1280: dbms_lob.writeappend(l_xml_blob,text_size,raw_data);
1281:
1282: hr_utility.trace('Get Length l_xml_clob ' ||dbms_lob.getlength(l_xml_blob) );
1897:
1898: dbms_lob.createtemporary(l_temp_blob,false,DBMS_LOB.CALL);
1899: dbms_lob.open(l_temp_blob,dbms_lob.lob_readwrite);
1900:
1901: raw_data:=utl_raw.cast_to_raw(l_final_xml_string);
1902: text_size:=utl_raw.length(raw_data);
1903:
1904: -- dbms_lob.writeappend(l_final_xml,text_size,raw_data);
1905:
1898: dbms_lob.createtemporary(l_temp_blob,false,DBMS_LOB.CALL);
1899: dbms_lob.open(l_temp_blob,dbms_lob.lob_readwrite);
1900:
1901: raw_data:=utl_raw.cast_to_raw(l_final_xml_string);
1902: text_size:=utl_raw.length(raw_data);
1903:
1904: -- dbms_lob.writeappend(l_final_xml,text_size,raw_data);
1905:
1906: /*dbms_lob.writeappend(l_final_xml,
1903:
1904: -- dbms_lob.writeappend(l_final_xml,text_size,raw_data);
1905:
1906: /*dbms_lob.writeappend(l_final_xml,
1907: utl_raw.length(utl_raw.cast_to_raw(l_final_xml_string)),
1908: utl_raw.cast_to_raw(l_final_xml_string)
1909: );*/
1910: l_temp_blob := append_to_lob(l_final_xml_string);
1911: dbms_lob.append(l_final_xml,l_temp_blob);
1904: -- dbms_lob.writeappend(l_final_xml,text_size,raw_data);
1905:
1906: /*dbms_lob.writeappend(l_final_xml,
1907: utl_raw.length(utl_raw.cast_to_raw(l_final_xml_string)),
1908: utl_raw.cast_to_raw(l_final_xml_string)
1909: );*/
1910: l_temp_blob := append_to_lob(l_final_xml_string);
1911: dbms_lob.append(l_final_xml,l_temp_blob);
1912:
1915: hr_utility.trace('Get Length l_final_xml ' ||dbms_lob.getlength(l_final_xml) );
1916:
1917: dbms_lob.append(l_final_xml,lc_emp_blob);
1918:
1919: raw_data:=utl_raw.cast_to_raw(l_last_xml_string);
1920: text_size:=utl_raw.length(raw_data);
1921:
1922: --dbms_lob.writeappend(l_final_xml,text_size,raw_data);
1923:
1916:
1917: dbms_lob.append(l_final_xml,lc_emp_blob);
1918:
1919: raw_data:=utl_raw.cast_to_raw(l_last_xml_string);
1920: text_size:=utl_raw.length(raw_data);
1921:
1922: --dbms_lob.writeappend(l_final_xml,text_size,raw_data);
1923:
1924: /*dbms_lob.writeappend(l_final_xml,
1921:
1922: --dbms_lob.writeappend(l_final_xml,text_size,raw_data);
1923:
1924: /*dbms_lob.writeappend(l_final_xml,
1925: utl_raw.length(utl_raw.cast_to_raw(l_last_xml_string)),
1926: utl_raw.cast_to_raw(l_last_xml_string)
1927: );*/
1928:
1929:
1922: --dbms_lob.writeappend(l_final_xml,text_size,raw_data);
1923:
1924: /*dbms_lob.writeappend(l_final_xml,
1925: utl_raw.length(utl_raw.cast_to_raw(l_last_xml_string)),
1926: utl_raw.cast_to_raw(l_last_xml_string)
1927: );*/
1928:
1929:
1930: l_temp_blob := append_to_lob(l_last_xml_string);