Dear All, I using Oracle Database 11g Enterprise Edition Release 184.108.40.206.0 - 64bit Production and my DB nls configration contents are writing at down side. I'm using .Net web services with this DB. I get or set some geometric table to DB. Normally I set a geometric query from .Net web services I'm setting session nls_numeric_characteristics for ',.' and my geometric tables sdo_srid value is null. I'm changing my sdo_srid null to 2321 (ED50) after I want to using my web services but my DB cannot execute alter session nls_numeric_characteristics for ',.' but when I return back for geometric tables sdo_srid 2321 to null value after then alter sesion nles_numeric_characteristics for ',.' is running and don't has a problem. What am I doing for this situation? I don't understand why? Because sdo_srid value don't interested with nls_numeric_characteristics. Finally if am I changing sdo_srid null to 2321 then ALTER SESSION SET NLS_NUMERIC_CHARACTERS = ',.' is not execute in DB (sending from .Net with OracleDataAccess.dll) but if sdo_srid is null then alter session command is running with success. What am I doing for this problem?
With Best Rgards.
NLS Session Configration
NLS_TIMESTAMP_FORMAT DD/MM/RRRR HH24:MI:SSXFF
NLS_TIME_TZ_FORMAT HH24:MI:SSXFF TZR
NLS_TIMESTAMP_TZ_FORMAT DD/MM/RRRR HH24:MI:SSXFF TZR