Language of SQL*Loader Results Title can not be Changed by NLS_LANG Before 12c (Doc ID 2172122.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 12.1.0.2 [Release 10.2 to 12.1]
Information in this document applies to any platform.

Symptoms

Language of SQL*Loader Results Title can not be changed by NLS_LANG before 12c.

- In pre-12c Oracle releases, the sqlldr results title from the log file is displayed in English, even if NLS_LANG is set to Non-English such as GERMAN_GERMANY.WE8MSWIN1252 or JAPANESE_JAPAN.JA16SJISTILDE.

Example:
------------
> echo $NLS_LANG
JAPANESE_JAPAN.JA16SJISTILDE

Pre-12c Sqlldr log file shows:

Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
N1 FIRST * , O(")CHARACTER
V1 NEXT * , O(")CHARACTER

- From 12c, Sql*Loader supports Multi-Language characters when NLS_LANG is set to Non-English. e.g Japanese for the example above.

12c Sqlldr log file shows:

列名 位置 長さ 用語暗号化データ型
------------------------------ ---------- ----- ---- ---- ---------------------
N1 FIRST * , O(")CHARACTER
V1 NEXT * , O(")CHARACTER

 

Changes

 None.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms