I searched through the forum but could not find an answer.
I get the warning:
main_program: The NLS character map <ASCL_MS1252> specified may not be compatible with the character set specified by NLS_LANG;
you may get unexpected results from your database.
My settings are:
1)Character set specified by NLS_LANG: American_America.WE8ISO8859P1
2)Oracle Database NLS_LANGUAGE value: AMERICAN
in NLS_DATABASE_PARAMETERS and NLS_SESSION_PARAMETERS
3)On the target Oracle stage:
Select category to set map for: NCHAR/NVARCHAR2
Map name for 'NCHAR/NVARCHAR2': Project deault (ASCL_MS1252)
What's interesting is, it happens in one environment but doesn't happen in another. I thoroughly checked both environments and the settings look exactly the same.