Spatial Index Changes the NLS_NUMERIC_CHARACTERS setting for the Session (Doc ID 1132990.1)

Last updated on JUNE 30, 2010

Applies to:

Oracle Spatial - Version: 11.2.0.1 and later   [Release: 11.2 and later ]
Information in this document applies to any platform.

Symptoms


In Oracle release 11.2.0.1, the creation of a spatial index changes the NLS_NUMERIC_CHARACTERS setting for the session.

See example below:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> conn TEST/TEST
Connected.

SQL> exec dbms_session.set_nls('nls_numeric_characters','", "');

PL/SQL procedure successfully completed.


SQL> select NLS_NUMERIC_CHARACTERS from nls_session_parameters;

PARAMETER                 VALUE
------------------------- -------------------------
NLS_NUMERIC_CHARACTERS    ,


CREATE INDEX cola_spatial_idx
ON cola_markets(shape)
INDEXTYPE IS MDSYS.SPATIAL_INDEX;

1 row created.


SQL> select NLS_NUMERIC_CHARACTERS from nls_session_parameters;

PARAMETER                 VALUE
------------------------- -------------------------
NLS_NUMERIC_CHARACTERS    .,

The same results can be seen when running a SDO_WITHIN_DISTANCE query.


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms