Hi. I am new in using the XML functions in oracle. I was able to create the xml code however, when I open the code in xml editor it shows an error "sting literal was not closed. Error processing resource". It is because the values of one of the element attribute has apostrophe. How to resolve this issue?
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.