Oracle Enterprise NLS warning !

rockr · Post by **rockr** » Fri Feb 08, 2008 3:05 pm

Hey everyone,

I am loading a Oracle table (UPSERT) and I get this warning:

main_program: An NLS character map <ASCL_ASCII> is specified, but NLS_LANG is not set;
the NLS character map must be set to an ICU codepage which is equivalent to
the character set specified by NLS_LANG.

What does it mean ?

Thanks for looking!

ray.wurlod · Post by **ray.wurlod** » Fri Feb 08, 2008 4:56 pm

It means that NLS_LANG, the environment variable that Oracle uses for character map recognition, has not been set.

rockr · Post by **rockr** » Mon Feb 11, 2008 9:58 am

Hi Ray,

Where can I set the NLS_LANG variable, Can i do it on the job level or does it have to be on the project level, Where can I see and change the set parameter?

Thanks

sud · Post by **sud** » Mon Feb 11, 2008 12:14 pm

At a project level you can set from administrator which NLS to use. Even at job level, you can set the NLS_LANG parameter which should be defined as a environment variable. Also, for a particular stage, a particular NLS setting can be selected from the NLS tab in the stage properties.