Hi,
We have a customer in Russia trying to upgrade his database of our application. During the upgrade process, they noticed ORA-01858 error(probably when trying to enter value in the date field). I requested them for more details from v$parameters and temp_nls_params. Below are the changes I noticed. Can someone please help me understand what could have triggered the error?
Our insert statment is similar to:
create table table1 (date_col date);
insert into table1 values ('06-NOV-14');
Customer:
| NUM | Name | Value | Value | Session | System |
| 247 | nls_length_semantics | CHAR | FALSE | TRUE | IMMEDIATE |
| 233 | nls_territory | AMERICA | FALSE | TRUE | FALSE |
Name Value SCOPE
------------------------------------ --------------------------------------------- --------
NLS_CHARACTERSET AL32UTF8 DATABASE
NLS_LANGUAGE RUSSIAN DATABASE
NLS_LANGUAGE RUSSIAN INSTANCE
NLS_LANGUAGE AMERICAN SESSION
NLS_DATE_LANGUAGE RUSSIAN DATABASE
NLS_DATE_LANGUAGE INSTANCE
NLS_DATE_LANGUAGE AMERICAN SESSION
NLS_DATE_FORMAT DD.MM.RR DATABASE
NLS_DATE_FORMAT INSTANCE
NLS_DATE_FORMAT DD-MON-RR SESSION
Our parameters:
| NUM | Name | Value | Value | Session | System |
| 247 | nls_length_semantics | BYTE | FALSE | TRUE | IMMEDIATE |
| 233 | nls_territory | AMERICA | TRUE | TRUE | FALSE |
NLS_CHARACTERSET WE8MSWIN1252 DATABASE
NLS_LANGUAGE AMERICAN DATABASE
NLS_LANGUAGE AMERICAN INSTANCE
NLS_LANGUAGE AMERICAN SESSION
NLS_DATE_LANGUAGE AMERICAN DATABASE
NLS_DATE_LANGUAGE INSTANCE
NLS_DATE_LANGUAGE AMERICAN SESSION
NLS_DATE_FORMAT DD-MON-RR DATABASE
NLS_DATE_FORMAT INSTANCE
NLS_DATE_FORMAT DD-MON-RR SESSION
OS: Windows 7
DB version:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
"CORE 11.2.0.4.0 Production"
TNS for 64-bit Windows: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production