Skip to Main Content

Charset Problem with WB_XML_LOAD

740237Dec 10 2009
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
Post Details
Locked due to inactivity on Jan 7 2010
Added on Dec 10 2009
0 comments
954 views