This content has been marked as final. Show 8 replies
is there any size lmitataion for xml??
Bug 12418354 - DBMS_XSLPROCESSOR.clob2file fails with ORA-1426 for large(>2g) CLOBs [ID 12418354.8]
but i think you have <2g
also post your code
also you can try DBMS_XMLDOM.WRITETOFILE
xdata XMLTYPE; ... doc := DBMS_XMLDOM.NewDOMDocument(xdata); DBMS_XMLDOM.WRITETOFILE(doc, 'UTLDATA/marco.xml');
or dbms_lob like
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;
Before rushing to less efficient alternatives, let's try to understand your issue.
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?
- Which XML editor is that?
- Do you get any error?
Open the file with a text editor first and see if it looks OK.
what about text editor? for example notepad++ ;)
do you have any & or other like ?
try escape it by utl_i18n.escape_reference as in odie_63' example - Re: The XML page cannot be displayed Cannot view XML input using XSL stylesheet