Check if your pool support initial sql command sending. e.g. alter session set nls_date_format = 'mm/dd/yyyy hh24:mi:ss';
If not you can try to use login trigger to do the same for your application user.
For more details read docs:
start searching for the right doc here
look for Master Book list at the top
There is a GLO link in the shotcuts area so you can find
Message was edited by: Zoltan Kecskemethy added docs links
If you use APEX and its globalization mechanisms, then APEX will set the NLS environment before each processing and rendering of a page. It will use ALTER SESSION implicitly. AFAIK, ApEx has never relied on DB sessions keeping any of their state between web browser page request. All session state is kept in database tables and restored from there as required for a given accept/render cycle.
Regarding the recommendations, I do not know any document myself but I have asked my colleague in ApEx development and his personal recommendations are globalization chapters in:
"Oracle Application Express 3.2 - The Essentials and More [Kindle Edition]"; Matthew Lyon, Arie Geller; Kindle Edition / Paperback Edition; ISBN-13: 978-1847194527
"Expert Oracle Application Express"; multiple authors; Kindle Edition / Paperback Edition; ISBN-13: 978-1430235125
There is also the globalization chapter in the ApEx docs, of course.
Thanks Sergiusz. You are correct about the Globalization parameters in the Application Settings. However, I need the same application to display dates and numbers in a Spanish format for one user of the app and in English for another user of the same app. So I need to set them at runtime, not in the settings of the app.
Thanks also for your recommendations for reading. I am looking into all of it.
Thanks for the information. I am checking with my hosting company on having the connection pool execute the alter session. However, I will need even that to be dynamic since each app user will have their own setting. I just need to find the proper place to execute the alter session.
The Globalization Support Guide has been very helpful. While I haven't found the answer to my specific question, it is a great source for understanding how the NLS settings affect both client and server. This is definitely a complicated topic and will take quite some time to master. Thanks for the redirect.