2 Replies Latest reply: Apr 5, 2013 4:30 PM by Another_user RSS

    nls paramater change error

    708631
      Im running oracle 10g xe.

      Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product
      PL/SQL Release 10.2.0.1.0 - Production
      "CORE     10.2.0.1.0     Production"
      TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
      NLSRTL Version 10.2.0.1.0 - Production
      My company has an internal tool that connects to databases, it used to work fine for connecting to mine. but suddenly i get this error when trying to connect.
      Error:java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-01861: literal does not match format string ORA-06512: at line 7 
      
      Sorry. Unable to connect to your database.
      I think that a nls paramater has changed (one of the other db people here changed it as I have not made any nls changes before today).

      Here are my nls paramaters :
      NLS_CALENDAR     GREGORIAN
      NLS_CHARACTERSET     WE8MSWIN1252
      NLS_COMP     BINARY
      NLS_CURRENCY     $
      NLS_DATE_FORMAT     DD-MON-RR
      NLS_DATE_LANGUAGE     AMERICAN
      NLS_DUAL_CURRENCY     $
      NLS_ISO_CURRENCY     AMERICA
      NLS_LANGUAGE     AMERICAN
      NLS_LENGTH_SEMANTICS     BYTE
      NLS_NCHAR_CHARACTERSET     AL16UTF16
      NLS_NCHAR_CONV_EXCP     FALSE
      NLS_NUMERIC_CHARACTERS     .,
      NLS_SORT     BINARY
      NLS_TERRITORY     AMERICA
      NLS_TIMESTAMP_FORMAT     DD-MON-RR HH.MI.SSXFF AM
      NLS_TIMESTAMP_TZ_FORMAT     DD-MON-RR HH.MI.SSXFF AM TZR
      NLS_TIME_FORMAT     HH.MI.SSXFF AM
      NLS_TIME_TZ_FORMAT     HH.MI.SSXFF AM TZR
      could a nls paramater change cause this issue ?
      Does anything look off ?