xdata XMLTYPE; ... doc := DBMS_XMLDOM.NewDOMDocument(xdata); DBMS_XMLDOM.WRITETOFILE(doc, 'UTLDATA/marco.xml');
dbms_lob.open(xmlString,DBMS_LOB.LOB_READONLY); loop -- read the lob data dbms_lob.read(xmlString,amount,position,charString); utl_file.put_line(fileHandle, charString); position := position + amount; end loop;
when i am query for more than 75 row the generated xml not able to open in xml editor,but it is fine for 74 rows.What does "not able to open" mean?
insa wrote:Again, what XML editor are you using? Web browser (IE, Firefox)?
When i m trying to open it on XML editor,following error showing-
Unable to load: XML parse error.
Error on line 3 at position 638.
An invalid character was found in text content.