1

I found out my servers, running Oracle 10g, were not initializing with the same NLS_SORT value when using the sqlplus binary.

Is there a way to set the default NLS_SESSION_PARAMETERS for every instance of sqlplus?

PS: The idea is not to do an ALTER SESSION at the beginning of every sql script.

altermativ
  • 690
  • 1
  • 6
  • 20

2 Answers2

1

the NLS parameters are specified by the client application. SQL*Plus on windows will have its parameters defined in the registry (same as the ORACLE_HOME where it is installed). On *nix systems the paremeters are defined as environment variable.

You can find additionnal information in the documentation.

Vincent Malgrat
  • 66,725
  • 9
  • 119
  • 171
0

Use an ON LOGON trigger to do the ALTER SESSION?

Then you can do it in one place and won't have have to change every client.

cagcowboy
  • 30,012
  • 11
  • 69
  • 93