I have been working with Oracle XML DB of version 11gR2. I have created a XML table with column as XMLType(Binary XMLType).
Question 1: When I insert a XML document, all the single quotes in the attributes list gets converted to double quotes automatically. How can I get rid of this? Because I have to reprocess the entire XML document when I have to fetch it.
Question 2: When I tried to retrieve I have used function getclobval(). This is working well with SQLPLUS and SQL Developer. However when I run this query through OCI, I am getting the error "ORA-00911: invalid character"
Can anyone help me on the above two questions?