63: --
64: -- l_str1 := '
65: l_str1 := '';
66:
67: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);
68: dbms_lob.open(l_clob, DBMS_LOB.LOB_READWRITE);
69: --
70: dbms_lob.writeappend(l_clob, LENGTH(l_str1), l_str1);
71: --
64: -- l_str1 := '
65: l_str1 := '';
66:
67: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);
68: dbms_lob.open(l_clob, DBMS_LOB.LOB_READWRITE);
69: --
70: dbms_lob.writeappend(l_clob, LENGTH(l_str1), l_str1);
71: --
72: IF g_xml_element_table.COUNT > 0 THEN
66:
67: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);
68: dbms_lob.open(l_clob, DBMS_LOB.LOB_READWRITE);
69: --
70: dbms_lob.writeappend(l_clob, LENGTH(l_str1), l_str1);
71: --
72: IF g_xml_element_table.COUNT > 0 THEN
73: --
74: FOR table_counter IN g_xml_element_table.FIRST .. g_xml_element_table.LAST LOOP
92: '>' || g_xml_element_table(table_counter).tagvalue ||
93: '';
94: END IF;
95: --
96: dbms_lob.writeappend(l_clob, LENGTH(l_xml_element), l_xml_element);
97: --
98: END LOOP;
99: --
100: END IF;
130: --
131: -- l_str1 := '
132: l_str1 := '';
133:
134: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);
135: dbms_lob.open(l_clob, DBMS_LOB.LOB_READWRITE);
136: --
137: dbms_lob.writeappend(l_clob, LENGTH(l_str1), l_str1);
138: --
131: -- l_str1 := '
132: l_str1 := '';
133:
134: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);
135: dbms_lob.open(l_clob, DBMS_LOB.LOB_READWRITE);
136: --
137: dbms_lob.writeappend(l_clob, LENGTH(l_str1), l_str1);
138: --
139: IF g_xml_element_table.COUNT > 0 THEN
133:
134: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);
135: dbms_lob.open(l_clob, DBMS_LOB.LOB_READWRITE);
136: --
137: dbms_lob.writeappend(l_clob, LENGTH(l_str1), l_str1);
138: --
139: IF g_xml_element_table.COUNT > 0 THEN
140: --
141: FOR table_counter IN g_xml_element_table.FIRST .. g_xml_element_table.LAST LOOP
151: || g_xml_element_table(table_counter).tagvalue ||
152: '' || EOL;
153: END IF;
154: --
155: dbms_lob.writeappend(l_clob, LENGTH(l_xml_element), l_xml_element);
156: --
157: END LOOP;
158: --
159: END IF;