Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

xmlserialize with special characters

Martin L.Sep 1 2015 — edited Sep 1 2015

Hello,

I'm looking for a way to keep the special characters intact when i use xmlserialize :

When i run this query :

select xmlserialize(content xmltype('<Owner>Grand''co</Owner>').extract('/*') indent)       

from dual;

i get this result :

<Owner>Grand&apos;co</Owner>

I would like to keep the " ' " instead of having the "&apos;".

Does anyone have a solution ?

Thank you

Martin

Message was edited by: Martin L.

This post has been answered by odie_63 on Sep 1 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 29 2015
Added on Sep 1 2015
4 comments
1,078 views