This content has been marked as final. Show 3 replies
Well, assuming there is an associated end tag (aka </TEST>) somewhere in your XML, then the XML fragment you show is well-formed XML.
If by "XML functions", you mean something like XMLElement/XMLForest/XMLAgg, then you can be safe to know that it generates well-formed XML.
What is this "xml editor" that you mention but don't name. It sounds as if the issue lies with that tool, based off what little you have provided.
The more details you provide, the better answer you get.
I thought that the xml editor was not able to display it properly. I was wrong. When I generated the XML code, I saved it in oracle 10g db. If I spool the code in 10g DB it is ok. But when I spool it using shell script which has oracle 9i DB, the output was cut off. The rest of the XML element starting from the code above were not spool to the file. And then when I open it in microsoft xml editor, the error comes out.
Edited by: caylee on Oct 26, 2012 12:20 PM
This sounds like a bug in 9i. You should probably consider upgrading to 11g