This content has been marked as final. Show 5 replies
What is your database characterset?
What are your client NLS lang settings?
Thanks for your reply. The nls_language of database is AMERICAN. Client language is AMERICAN too.
ampersands are usually not allowed in xml documents! Therefore you should avoid wherever possible.
But - you can circumvent with
SQL> declare xml XMLType; begin select xmlelement(noentityescaping "test", 'A&B') into xml from dual; dbms_output.put_line(xml.getstringval()); end; / <test>A&B</test>
Thanks. But I need load XML docs into database. The docs contain many "&", such as "&", " " as so on.
Please post the entire document that is being loaded. An '&' is only allowed as part of a entity escape. Some are standard such as '& amp;'. Others require a DTD in order to resolve.