Forum Stats

  • 3,814,157 Users
  • 2,258,828 Discussions
  • 7,892,595 Comments

Discussions

Charset Problem with WB_XML_LOAD

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
Tagged:
This discussion has been closed.