NLS Mapping Error

paddu · Post by **paddu** » Fri Sep 01, 2006 9:32 am

Hi All,

i am reading a Flat File (pipe delimited) and writing into Oracle.
i see the warning below for about 5 times and my job aborts.

nls_map_buffer_in() - NLS mapping error, row 1812940 (approx), row = "0106390580|000010||EA|||52138Z||20060116||00000000|24.000 |24.000 |24.000 |0120|00001|EA|24.000 |124.80 ||CAMPO_CI|20060116|070708|Z|999||||||1.000 |1.000 |01|06|99|I|USD|ZSAM|20300230798031|1.0000000000000000E+00|1.0000000000000000E+00|1.0000000000000000E+00|Z1||5.520 |FCA||ZSAM|USD|91868US|SAMPLES||||||91868US|0.000 |0.00 |0.00 |5.520 |1.000 |1.000 |USD|100|1.000 |1TM|52138ZU|0090|OCLI/DR GERALD D?fAV|20060116|000||06223909440790799|||00000000|00000000|||A|24.000 |00009C|||00000000|1000||T15|RT03|EA|00000000|0090|52138Z|52138Z|USD||0090|C|C|20060116|0.00 |0.00 |0.00 |0.00 |0.00 ||0.000 |EA|0.00 |0.00 |20060116|LB|||0.000 |"

Any suggestions appreciated
Thanks
Paddu

thumsup9 · Post by **thumsup9** » Fri Sep 01, 2006 10:03 am

What are your NLS Settings for your job. What happens when you set NLS to NONE.

DeepakCorning · Post by **DeepakCorning** » Fri Sep 01, 2006 10:47 am

thumsup9 wrote:What are your NLS Settings for your job. What happens when you set NLS to NONE.

As per my knowledge This error comes when oyu have special char fields in the some columns and the NLS setting of the job can not handle those special characters. Check out for those special characters and change the NLS setting for the job accordignly..

ray.wurlod · Post by **ray.wurlod** » Fri Sep 01, 2006 9:24 pm

The "?" in "OCLI/DR GERALD D?fAV" indicates the actual character that could not be mapped. You may like to check your source to verify that that character is properly encoded. You may require a hex editor for this task.

vjeran · Post by **vjeran** » Mon Sep 04, 2006 5:43 am

HI,

look at this topic. There is solution for NLS problem you have.
viewtopic.php?t=100188

BR Vjeran