Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Date format bug trying to set NLS_DATE_FORMAT

Hi,

I am experiencing the following date format problem in APEX. (Look that APEX says me to use the same date I am inputting)

This happens in the Cloud and apex.oracle.com (Version 23.1).

To reproduce the problem:

  1. Create an app with the following Globalization Attributes.

2. Create an Date Picker item (with NO format mask) and a button to submit the page

3. In the Security Attributes > Initialization PL/SQL Code, type the following code:

BEGIN
EXECUTE IMMEDIATE 'alter session set nls_date_format = ''YYYY-MON-DD'' ';
END;

4. Select any date and click the button in the page and the error message is shown.

This post has been answered by Carsten Czarski-Oracle on Sep 3 2023
Jump to Answer
Comments
Post Details
Added on Sep 1 2023
2 comments
78 views