How to do insert an xml with a XML reserved character [message #292739] |
Wed, 09 January 2008 15:12  |
jonathan184
Messages: 21 Registered: November 2006
|
Junior Member |
|
|
How to do insert an xml with a XML reserved character
Basically ig ot an insert statement, where i am trying to insert a xml in CLOB field but in the xml it contains XML reserved character which is the & I tried replacing it with & but the insert statement stilld does not work. How would i do this?
here is what i have, How could i put this in a oracle statement.
I tried replacing the & with & but got the same issue not accepting the amber sign
<Condition>
<Value>customer & me</Value>
</Condition>
|
|
|
|
|
|
|
|
|
|
|
|
Re: How to do insert an xml with a XML reserved character [message #292757 is a reply to message #292745] |
Wed, 09 January 2008 15:53   |
jonathan184
Messages: 21 Registered: November 2006
|
Junior Member |
|
|
Here is what we don't know.
What OS name & version? if you are talking about the client windows vista ultimate and db is on HP unix not sure of version
What Oracle DB version to 4 places? 9i thats all i know
What client s/w name & version?
Oracle9i
Client Release Notes
Release 2 (9.2.0.1.0) for Windows
client interpreter is PLSQL Developer 6.05.931
What actual error message?
ORA-31011:XML parsing failed
ORA-19202:Error occurred in XML processing
LPX-00242: Invalid use of ampersand(")character(use amp;)
So i replaced the & with & then i tried amp;
and got this message
a popup window with a title variables two columns
name - amp value & then i got ok and cancel i clicked ok and the same error above came up.
|
|
|
|