Localization (Before Running SQLLOADER)
SqlLoader is an utility tool and can not change the environment parameters, especially the NLS Localization parameter. From Checklist before starting SQL*Loader
You have to change them:
- in the database.
Ex: Set NLS_LANG to the desired territory and character set to prevent wrong data to be loaded or getting errors due to this data.
NLS_LANG=<Language_Territory.Characterset>
NLS_LANG="Dutch_The_Netherlands.WE8ISO8859P15"
- or in the batch file / console that start SQLLoader
set NLS_LANG=DUTCH
sqlldr usere@tnsnames CONTROL=myControlFile.ctl skip=1