Hi experts,
I have a gz file from other system(solaris), which is ftped to our system(solaris).
After gunzip, the file is a xml file and we are using ORACLE built in xml transformiing tool ORAXSL to transform XML to TXT.
Now the issue is we come accross issue regarding UTF8 as below:
Error occurred while parsing RDC2010052100149253.xml: Invalid UTF8 encoding.
As informed by our SA/DBA, we have set NLS_LANG as below in shell script, still got same error. (Even we use dos2unix -ascii to transform the unzipped xml file)
export NLS_LANG=AMERICAN_AMERICA.UTF8
Is there anyway to fix this issue?
Any help to clue will be highly appreciated.