DBA Data[Home] [Help]

APPS.IES_META_DATA_SOURCE dependencies on DBMS_LOB

Line 39: DBMS_LOB.WRITEAPPEND(xml_clob, LENGTH(xml_buffer), xml_buffer);

35: BEGIN
36: if (nvl(length(xml_buffer), 0) + length(buffer) <= 32000) then
37: xml_buffer := xml_buffer || buffer;
38: else
39: DBMS_LOB.WRITEAPPEND(xml_clob, LENGTH(xml_buffer), xml_buffer);
40: xml_buffer := buffer;
41: end if;
42:
43: END appendXMLClob;

Line 100: DBMS_LOB.CreateTemporary(xml_clob, TRUE, DBMS_LOB.CALL);

96: len number;
97: BEGIN
98: xml_buffer := null;
99: xml_clob := null;
100: DBMS_LOB.CreateTemporary(xml_clob, TRUE, DBMS_LOB.CALL);
101:
102: convertObjectToXML(objId);
103: DBMS_LOB.WRITEAPPEND(xml_clob, LENGTH(xml_buffer), xml_buffer);
104: --dbms_output.put_line('length is ' || to_char(dbms_lob.getlength(xml_clob)));

Line 103: DBMS_LOB.WRITEAPPEND(xml_clob, LENGTH(xml_buffer), xml_buffer);

99: xml_clob := null;
100: DBMS_LOB.CreateTemporary(xml_clob, TRUE, DBMS_LOB.CALL);
101:
102: convertObjectToXML(objId);
103: DBMS_LOB.WRITEAPPEND(xml_clob, LENGTH(xml_buffer), xml_buffer);
104: --dbms_output.put_line('length is ' || to_char(dbms_lob.getlength(xml_clob)));
105: return xml_clob;
106: END getObjectAsXML;
107:

Line 104: --dbms_output.put_line('length is ' || to_char(dbms_lob.getlength(xml_clob)));

100: DBMS_LOB.CreateTemporary(xml_clob, TRUE, DBMS_LOB.CALL);
101:
102: convertObjectToXML(objId);
103: DBMS_LOB.WRITEAPPEND(xml_clob, LENGTH(xml_buffer), xml_buffer);
104: --dbms_output.put_line('length is ' || to_char(dbms_lob.getlength(xml_clob)));
105: return xml_clob;
106: END getObjectAsXML;
107:
108: -- **********************************************************************