2 Replies Latest reply: Jan 22, 2013 7:24 AM by mschnatt RSS

    SDO_SRID & NLS_NUMERIC_CHARACTERS EXECUTION PROBLEM

    985885
      Dear All, I using Oracle Database 11g Enterprise Edition Release 11.2.0.1.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_LANGUAGE     TURKISH
      NLS_TERRITORY     TURKEY
      NLS_CURRENCY     TL
      NLS_ISO_CURRENCY     TURKEY
      NLS_NUMERIC_CHARACTERS     ,.
      NLS_CALENDAR     GREGORIAN
      NLS_DATE_FORMAT     DD/MM/RRRR
      NLS_DATE_LANGUAGE     TURKISH
      NLS_SORT     TURKISH
      NLS_TIME_FORMAT     HH24:MI:SSXFF
      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
      NLS_DUAL_CURRENCY     YTL
      NLS_COMP     BINARY
      NLS_LENGTH_SEMANTICS     BYTE
      NLS_NCHAR_CONV_EXCP     FALSE