XML illegal characters (XMLTYPE parsing)
Multi tool use
Clash Royale CLAN TAG#URR8PPPXML illegal characters (XMLTYPE parsing)
The following are usually mentioned as illegal XML characters: < > & ' "
In PLSQL, when I convert an element having a VARCHAR2 value with the above characters to XMLTYPE, only < and & are reported as causes for XML non-well-formedness. 5 XML documents below, only the first (containing the less than mark) and the last one (containing the ampersand) are being flagged down as not-well formed. Is this as expected?
---------------------------------
<?xml version="1.0" encoding="utf-8"?>
<Request>
<param1>test<message<param1>
</Request>
---------------------------------
<?xml version="1.0" encoding="utf-8"?>
<Request>
<param1>test>message<param1>
</Request>
---------------------------------
<?xml version="1.0" encoding="utf-8"?>
<Request>
<param1>test'essage<param1>
</Request>
---------------------------------
<?xml version="1.0" encoding="utf-8"?>
<Request>
<param1>test"message<param1>
</Request>
---------------------------------
<?xml version="1.0" encoding="utf-8"?>
<Request>
<param1>test&message<param1>
</Request>
---------------------------------
@JimGarrison - Isn't the OP saying that
< and & is available in the data and hence reporting an issue ?– Sudipta Mondal
1 hour ago
<
&
It is not at all clear what the OP is asking. That is one possible interpretation but the question does not have enough context to be unambiguous.
– Jim Garrison
1 hour ago
By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.
We have no idea. You are asking us to guess what is in your data and why you think it should be flagged as invalid. If you would like some help, start by visiting the help center, taking the tour and reading How to Ask, to learn how to use this site effectively. Then edit your post to include a sample of "invalid" XML and explain how you think the behavior contradicts Oracle's documentation.
– Jim Garrison
1 hour ago