|
|
Re: LPX-00230: invalid character 0 (U+0000) found in a Name or Nmtoken [message #665724 is a reply to message #664827] |
Mon, 18 September 2017 09:11 |
|
sss111ind
Messages: 636 Registered: April 2012 Location: India
|
Senior Member |
|
|
Hi All,
We have implemented the following code and it resolved the problem.
--SAMPLE xml ampersand(&) and appstrope(') for which problem happening
<![CDATA[<?xml version="1.0" encoding="UTF-8"?><Record><Details><NAME>AARIF & AGENCIES</NAME><INVOICE>0945005251 / 16 & 17~0945005255 / 14 & 15~0945005256 / 13~</INVOICE></Details><Details><NAME>G A V & TRANSPORTS</NAME><INVOICE><![CDATA[0937000136 / 8-0.50SR & T~0945005264 / 8~0945005269 / 9~0945005272 / 7~0945005362 / 18~0945005376 / 4~0043013253 / FRT DEBIT-WFA~0022049721 / TRR EARTH'MOVERS~0945005385 / 3~]]></INVOICE></Details><Details><NAME>VENKATESAN M</NAME><INVOICE><![CDATA[0945005078 / 15~0945005077 / 118~0945005075 / 119~0945005069 / 97~0945005067 / 96~0945005060 / 123~0945005059 / 122~0945005036 / 121~0945005034 / 120~0937000126 / 122 & 123-2.28SR~]]></INVOICE></Details></Record>]]>
--Finding the way to handle this
PROCEDURE TEST_insert(p_salxml CLOB) IS
l_input_xml XMLTYPE;
BEGIN
BEGIN
l_input_xml := XMLTYPE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(rtrim(ltrim(p_salxml,
chr(10) || ' '),
chr(10) || ' '),
'<?xml version="1.0" encoding="UTF-8"?>',
''),
'<![CDATA[',
''),
']]>',
''),'&','&'),''',''),'&','&'));
END;
END TEST_insert;
Thank you all,
Nathan
|
|
|