XML Database (MOSC)

MOSC Banner

LPX-00200:could not convert from encoding UTF-16 to ISO-8859-1

edited Dec 12, 2011 3:50AM in XML Database (MOSC) 3 commentsAnswered
 I have a process which reads information from a file being sent to our organization.I use DBMS_LOB.LoadClocbFromFile to load the data into a table with a clob column.
Once the data is in the clob field I try to set another column of xmltype in the same table 
with a 

update uw_file_import_log set xml_data=xmltype(src_clob,nls_charset_id('AL16UTF16')
  where query_id=p_query_id;

When I do this in  development 11g database which has NLS_CHARACTERSET = WE8MSWIN1252 is works fine.

When I do it in a 10 g environment which has NLS_CHARACTERSET = WE8ISO8859P1 is gives an error.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center