We are trying to solve a problem relating to the decimal character used by
sessions created by our user ID.

We ran this SQL

SELECT * FROM NLS_INSTANCE_PARAMETERS;

and it returned in part

NLS_NUMERIC_CHARACTERS

We also ran this SQL

SELECT * FROM NLS_SESSION_PARAMETERS;

and it returned in part

NLS_NUMERIC_CHARACTERS ,


Note that the NLS_NUMERIC_CHARACTERS has a comma indicated. This is
consistent with our observations. We have to ensure that numeric values have
the comma "," as a decimal separator for the database to accept them.

When we log in we do not explicitly change this setting. Where would this
setting be determined for our user? How would we change it back to the
default, the period "." for our decimal separator?

The user Id will be used for both interactive "human" login and for sessions
created by certain client applications.

Thanks

J.