Currently we are using Apex Listener 2.0.2 in a non-Apex application. To display 4-digit year in the application web pages, Apex Listener configuration has the following in defaults.xml,
log.before_proc has, among other lines of code,
After doing the same setup in ORDS 3.0.3, we are seeing years displayed as 2-digits in the application web pages. I have confirmed that log.before_proc and log.after_proc are getting called.
Anyone else seeing this behavior and know what to do. Changing the application to use to_char(date, 'DD-MON-YYYY') all over would be a show stopper.
You need to train your programmers to never trust the default NLS settings when doing implicit conversions.
Try putting the DBMS_SESSION.SET_NLS() command in the Application's "Initialize Session PL/SQL Code" section.
IMHO - the application should have been using TO_CHAR() from the beginning.