Stack Overflow
Stack Overflow

Questions tagged [nls-lang]

NLS_LANG is a client side environment variable used to define language, territory and character set properties and to specify the locale behavior.

64 questions
0
votes
1 answer

ORA-12705: Cannot access NLS data files or invalid environment specified Oracle V 12.2.0.7 Windows 10

I am trying to login into sqlplus at the windows command prompt and get the ORA-12705 error. I have tried setting the NLS_LANG variable to a couple of times (as shown below) with no success. set NLS_LANG=american_america.US8PC437 set…
Glyn WIlliams
  • 1
  • 1
0
votes
1 answer

SSRS 2012 to SSRS 2016 causing reports to show different NLS parameters (Oracle 12c (12.1.0.2.0) )

We've recently updated SSRS to 2016 from 2012 - once we updated the server and installed the ODAC we noticed the NLS settings change for reports (for example if we run SELECT * FROM V$NLS_PARAMETERS locally the NLS settings default to UK however…
Blake_SO
  • 1
  • 1
0
votes
3 answers

Oracle NLS_TERRITORY overrides NLS_DATE_FORMAT

When in PHP application I specify ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS'; ALTER SESSION SET NLS_DATE_LANGUAGE = 'RUSSIAN'; the output data format is as expected 2020-01-31 21:21:47 But when I add ALTER SESSION SET…
MaterialGirl
  • 363
  • 2
  • 10
  • 22
0
votes
1 answer

Ö and other special characters not getting saved correctly in the client data base

When I execute the code at my end, the characters get saved correctly. But when the same code with the same data is executed at client side, the characters change when they are written to the database and that causes issues when they are displayed…
siddhant
  • 35
  • 6
0
votes
2 answers

Oracle Report generating in Greek language

After the migration Oracle application from Windows(on premise) to Unix(cloud), reports are generated in Greek language. Please help us to generate it in English or French. Application Server : WebLogic Oracle version : 12.1.0.2.0 We have made…
Manoj
  • 39
  • 1
  • 6
0
votes
2 answers

NLS_CHARACTERSET in nls_session_parameters returns None

An application I'm using with Oracle seems to be having issues with characters, and I ran the queries below to check on the CHARACTERSET. SELECT * FROM nls_session_parameters WHERE PARAMETER='NLS_CHARACTERSET'; SELECT * FROM nls_database_parameters…
Sattesh Maran
  • 11
  • 1
  • 3
0
votes
0 answers

Oracle NLS_LANG set properly(WE8ISO8859P1) but sessions starts in US7ASCII

On Linux Open SuSE I have my env variable set properly, meaning NLS_LANG is set to WE8ISO8859P1, and it is all started and exported in ~/.bashrc However when the system starts and connects to Oracle the session always starts as US7ASCII What am I…
sh4rk
  • 3
  • 4
0
votes
0 answers

How to read different national languages(NLS) into python?

I'm trying to read data from a Teradata table into python 3.6 and then insert that data into Oracle. It is basically an extract and load process as I'm not transforming the data. This Teradata table has columns where there are characters in many…
Jit
  • 633
  • 2
  • 6
  • 10
0
votes
0 answers

ORA-12705 NLS_LANG error when deploying Oracle as database for WSO2 APIM

I'm facing an issue when setting WSO2 APIM databases with Oracle. When I launch the WSO2 APIM server, I get the fllowing error : ORA-12705: Cannot access NLS data files or invalid environment specified I don't know how to solve this. My…
tom johnes
  • 387
  • 1
  • 3
  • 12
0
votes
2 answers

change charset utf8 in oracle

I have problem with transform data in kazakh language from one db oracle to other oracle. Source database has AL32UTF8 NLS_CHARACTERSET (according to v$nls_parameters), target has CL8MSWIN1251 how to solve this? I inserted raw with informatica
Abylay
  • 11
  • 4
0
votes
1 answer

Set the NLS_LANG

We have a database with AL32UTF8 as character set. Our application supports EN, FR, DE and JP languages. In Each release we insert new labels into the table managing the translations. what the NLS_LANG of the client should be, to ensure that french…
Bilel Chaouadi
  • 903
  • 1
  • 10
  • 28
0
votes
0 answers

How fix ORA-00604 and ORA-12705 during sql-maven-plugin execution?

I am trying to drop tablespace in oracle via maven plugin. Here is the configuration: org.codehaus.mojo sql-maven-plugin 1.5 …
Cherry
  • 31,309
  • 66
  • 224
  • 364
0
votes
0 answers

Changing environment variables from SAS

when I connect to an Oracle database, some symbols are not displayed properly. In Oracle I would change the nls_language parameter for the session using: alter session set nls_language and alter session set nls_territory But how can I change…
Jdzel
  • 159
  • 1
  • 3
  • 17
0
votes
0 answers

Running legacy OCI app under Windows Server 2012 R2 results in crash

I have an application which uses the OCI 7 API. This application is successfully deployed on a variety of configurations like WS2003/Oracle9 and WS2008 R2/Oracle12 (r1). I am now trying to deploy the app on WS2012 R2 but I am facing a frustrating…
anders
  • 772
  • 1
  • 10
  • 17
0
votes
1 answer

How do I change the NLS_CHARACTERSET setting on Windows 7 for Oracle 11g ODBC client

I'm trying to retrieve data from an Oracle database into MS Access or Excel on to a Windows 7 PC. The data includes characters such as degree and diameter symbols. These are not displayed correctly on the PC. I can see that the data is stored…
Steve Watkins
  • 11
  • 1
  • 6
1 2 3
4
5