|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Stop making mediocre tutorials.The best tutorials are video! Camtasia Studio makes it easy to create engaging, buzz-building screen videos at any size, in any popular format. Download the free trial!
|
|
#1
|
|||
|
|||
|
invalid character
Hi ,
I wanted to insert an XML data in XMLTYPE table. The content of my xml file is : more test.xml <?xml version="1.0" encoding="ISO-8859-1"?> <Employee> <Name>Shailesh</Name> <spezial> ‰ spezial character </spezial> <Age>23</Age> </Employee> Shown below are the steps that I followed as per oracle documentation. create table test( filename varchar(200), xlmdoc xmltype); create directory XMLDIR as '/mydir'; insert into test(filename, xmldoc) values ('test.xml', xmltype.createxml(getdocument('XMLPATH','text.xml'))); ERROR at line 2: ORA-31011: XML parsing failed ORA-19202: Error occurred in XML processing LPX-00217: invalid character 8240 (\u2030) Error at line 4 ORA-06512: at "SYS.XMLTYPE", line 5 ORA-06512: at line 1 However I get this error. Please advise. Thanks, Rene |
![]() |
| Viewing: Dev Shed Forums > Databases > Oracle Development > invalid character |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|