Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 535.7K On-Premises Infrastructure
- 138.1K Analytics Software
- 38.6K Application Development Software
- 5.6K Cloud Platform
- 109.3K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
Charset Problem with WB_XML_LOAD
740237
Member Posts: 2
Hi all
My environment 11gr2 on Linux
one DB with NLS_CHARACTERSET AL32UTF8
second DB NLS_CHARACTERSET WE8MSWIN1252
I have the following Problem when loading xml Files with WB_XML_LOAD:
The code works fine as long I have no umlaut on both databases.
With umlaut the load of the File fails on DB with AL32UTF8 , but works with WE8MSWIN1252
I get the following error:
ORA-20007: Error occurred while retrieving XML document.
Base exception: null
ORA-06512: at "OWBSYS.WB_XML_LOAD_F", line 12
ORA-06512: at "OWBSYS.WB_XML_LOAD", line 4
ORA-06512: at line 28
The xml File comes with <?xml version="1.0" encoding="ISO-8859-1" standalone="yes"?>
Any idea?
Thanks in advance
Patrick
My environment 11gr2 on Linux
one DB with NLS_CHARACTERSET AL32UTF8
second DB NLS_CHARACTERSET WE8MSWIN1252
I have the following Problem when loading xml Files with WB_XML_LOAD:
The code works fine as long I have no umlaut on both databases.
With umlaut the load of the File fails on DB with AL32UTF8 , but works with WE8MSWIN1252
I get the following error:
ORA-20007: Error occurred while retrieving XML document.
Base exception: null
ORA-06512: at "OWBSYS.WB_XML_LOAD_F", line 12
ORA-06512: at "OWBSYS.WB_XML_LOAD", line 4
ORA-06512: at line 28
The xml File comes with <?xml version="1.0" encoding="ISO-8859-1" standalone="yes"?>
Any idea?
Thanks in advance
Patrick
This discussion has been closed.