Hi,
we are using dotConnect Universal with Oracle.
Lets assume this: Two Oracle clients installed on a machine "A" and "B".
"A" is the first in the Path
Aplication should use "B" so we add "Oracle_Home = B" to the connection string.
This works perfecly fine, its taking the OCI.dll from the "B" client.
But we have the impression that ist not taking the NLS_Lang setting from the "B" client, but uses the "A" client for that.
Could you please confirm that you not only using the OCI.dll but also all the settings from this special Oracle:home and not taking any defaults from the first client in the path ?
regards
Holger
NLS_LANG not taken from selected Oracle_Home
-
- Posts: 3
- Joined: Fri 25 Aug 2017 13:00
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: NLS_LANG not taken from selected Oracle_Home
We have reproduced the issue. We will investigate it and post the results here.
-
- Posts: 3
- Joined: Fri 25 Aug 2017 13:00
Re: NLS_LANG not taken from selected Oracle_Home
Hi, Any news on this, any idea how long investigation will take ?
regards
regards
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: NLS_LANG not taken from selected Oracle_Home
This is the Oracle Client behavior. The same NLS_LANG is used for all Oracle Clients with the same major version. NLS_LANG value is taken from the first loaded Oracle Client. For example, if you have two Oracle Clients 12.x, they both will have the same NLS_LANG. Since default home is loaded at first, its NLS_LANG is used for all Oracle Clients with the same major version.
We will investigate the possibility of affecting this situation from our side, but there is no timeframe.
We will investigate the possibility of affecting this situation from our side, but there is no timeframe.
-
- Posts: 3
- Joined: Fri 25 Aug 2017 13:00
Re: NLS_LANG not taken from selected Oracle_Home
Hi,
is this answer coming from your own investigation or is this a documented and well known Oracle issue?
Do you have any link to Oracle documentation where this is stated ?
is this answer coming from your own investigation or is this a documented and well known Oracle issue?
Do you have any link to Oracle documentation where this is stated ?
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: NLS_LANG not taken from selected Oracle_Home
It is coming from our investigation. We don't apply any additional Oracle Client settings to an Oracle session because we think that Oracle Client must do it itself. There were no problems with it before.
You can use the "Run Once Command" connection string parameter to set the necessary NLS_LANG value. For example, add the following string to your connection string:
You can replace 'AMERICAN' with any other NLS_LANGUAGE value. For more information, please refer to
https://www.devart.com/dotconnect/oracl ... tring.html
https://www.devart.com/dotconnect/oracl ... mmand.html
You can use the "Run Once Command" connection string parameter to set the necessary NLS_LANG value. For example, add the following string to your connection string:
Code: Select all
"Run Once Command=ALTER SESSION SET NLS_LANGUAGE= 'AMERICAN';"
https://www.devart.com/dotconnect/oracl ... tring.html
https://www.devart.com/dotconnect/oracl ... mmand.html