Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

Not able to set NLS_Lang

edited Sep 14, 2016 5:00AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 6 commentsAnswered

SQL> SELECT USERENV('LANGUAGE') "Language" FROM DUAL;

Language

----------------------------------------------------

AMERICAN_AMERICA.AL32UTF8

SQL> alter session set nls_language=&language;

Enter value for language: AMERICAN_AMERICA.AL32UTF8

old 1: alter session set nls_language=&language

new 1: alter session set nls_language=AMERICAN_AMERICA.AL32UTF8

alter session set nls_language=AMERICAN_AMERICA.AL32UTF8

*

ERROR at line 1:

ORA-00922: missing or invalid option

SQL> alter session set nls_language='&language';

Enter value for language: AMERICAN_AMERICA.AL32UTF8

old 1: alter session set nls_language='&language'

new 1: alter session set nls_language='AMERICAN_AMERICA.AL32UTF8'

ERROR:

ORA-12705: Cannot access NLS data files or invalid environment specified

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center