Line 212: IF (DBMS_LOB.INSTR(p_xml_clob, fnd_global.local_chr(10)) = 0) THEN
208: /*
209: * Do not attempt to print XML clob unless it contains
210: * CR-LFs.
211: */ 212: IF (DBMS_LOB.INSTR(p_xml_clob, fnd_global.local_chr(10)) = 0) THEN 213:
214: print_debuginfo(l_module_name, 'Clob does not contain '
215: || 'CR-LFs; cannot print entire XML Clob, '
216: || 'printing a snippet ..'
Line 230: l_xmlstr := dbms_lob.substr(p_xml_clob, 32767);
226:
227: /*
228: * Print the clob as an XML fragment.
229: */ 230: l_xmlstr := dbms_lob.substr(p_xml_clob, 32767); 231: LOOP
232:
233: EXIT WHEN l_xmlstr IS NULL;
234: