I have problem with special characters. I am generating an xml within Oracle using XMLForest. Data has special characters like � , � ,� etc...Once this file is generated, I store it as a CLOB. I, then, from the front end of my application take the file and apply the stylesheet(I need to do this to remove some nodes in the xml). But I am not able to open the file because of the special characters in the source file. How can I specify that these characters need to be escaped when I generate xml in Oracle?
Also, I have to apply stylesheet outside Oracle environment because XMLTransform function isn't working for me. Not sure if it was because of special characters again. I get this doubt because in my frontend, I am using dom4j to apply stylesheet to the source xml. I get an exception when I try to apply xsl to the raw xml. When I replace/remove special characters, I am able to apply xsl.