settting NLS_LANG

[nigel pendall]

We have an application developed by an external company with NLS_LANG set to American.

It contains some date functions that behave strangely and it has been said that this is because the NLS_LANG setting that plsql developer is using is not the same as that used by the database.

Where can I check the setting used by PLSQL developer. I have a forest of registry entries for ORACLE but do not know which one plsqldeveloper uses.

regards

nigel

 

[Marco Kalter]

If you go to Help > About and press the Info (I) button, you can see which Oracle Home PL/SQL Developer is using (this should be the Primary Oracle Home). Click on the "Registry" tab page to find the NLS_LANG for this particular home.

Note that you can change the Oracle Home that PL/SQL Developer will use through Tools > Preferences > Options. Just select the appropriate home from the Oracle Home selection list and restart PL/SQL Developer.

 

[til]

Well really, the external company should develop in such a way, that there programm runs with any nls Settings. Are they doing a to_date without format_mask? Or (even worse) a to_timestamp of a date *with* a mask?