Installation of 10/16/12 CPU causes ORA-01801 errors
Since installing the 10/16/12 CPU, getting lots of ORA-01801 errors after setting nls_date_format to something other than the default. Here's an example:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Automatic Storage Management, Oracle Label Security, OLAP,
Data Mining and Real Application Testing options
SQL>select 'New Date Format: '||sysdate from dual;
'NEWDATEFORMAT:'||SYSDATE
--------------------------
New Date Format: 31-OCT-12
1 row selected.
SQL>alter session set nls_date_format='MM/DD/RRRR';
Session altered.
SQL>select 'New Date Format: '||sysdate from dual;
select 'New Date Format: '||sysdate from dual
*
ERROR at line 1:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Automatic Storage Management, Oracle Label Security, OLAP,
Data Mining and Real Application Testing options
SQL>select 'New Date Format: '||sysdate from dual;
'NEWDATEFORMAT:'||SYSDATE
--------------------------
New Date Format: 31-OCT-12
1 row selected.
SQL>alter session set nls_date_format='MM/DD/RRRR';
Session altered.
SQL>select 'New Date Format: '||sysdate from dual;
select 'New Date Format: '||sysdate from dual
*
ERROR at line 1:
0