Oracle: Set NLS_PARAMETERS with sqlplus

Question

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.

Answer 1

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.

Answer 2

Hi altermativ,

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.