Hi,
Under Oracle APEX 24.2.11, I have a welcome page with a navigation menu with three list entries. I have created two Application items APP_DATE_FERMETURE with a static computation before regions for that item :
TO_DATE ('01/11/2026', 'DD/MM/YYYY')
and for APP_DATE_OUVERTURE before regions for this one:
TO_DATE ('01/04/2026', 'DD/MM/YYYY')
There a three list entries on the navigation menu. For each one of them, I have created a display condition exist :
Select 1 from dual WHERE CURRENT_DATE BETWEEN :APP_DATE_OUVERTURE AND :APP_DATE_FERMETURE
It works well under SQL Commands but I get an error when trying to access to the Welcome page :
-
is_internal_error: true
apex_error_code: APEX.CONDITION.UNHANDLED_ERROR
ora_sqlcode: -1858
ora_sqlerrm: ORA-01858: Caractère non numérique trouvé à la place d'un caractère numériqueORA-06512: à "APEX_240200.WWV_FLOW_DYNAMIC_EXEC", ligne 1626
ORA-06512: à "SYS.DBMS_SYS_SQL", ligne 2132
ORA-06512: à "SYS.WWV_DBMS_SQL_APEX_240200", ligne 822
ORA-06512: à "APEX_240200.WWV_FLOW_DYNAMIC_EXEC", ligne 1578
ORA-06512: à "APEX_240200.WWV_FLOW_DYNAMIC_EXEC", ligne 1668
ORA-06512: à "APEX_240200.WWV_FLOW_DYNAMIC_EXEC", ligne 1435
component.type: APEX_APPLICATION_LIST_ENTRIES
component.id: 15910914882550141
component.name: Réservation et paiement / (Booking and pay)
error_backtrace:ORA-06512: à "SYS.DBMS_SYS_SQL", ligne 2132
ORA-06512: à "SYS.WWV_DBMS_SQL_APEX_240200", ligne 822
ORA-06512: à "APEX_240200.WWV_FLOW_DYNAMIC_EXEC", ligne 1578
ORA-06512: à "APEX_240200.WWV_FLOW_DYNAMIC_EXEC", ligne 1626
ORA-06512: à "SYS.DBMS_SYS_SQL", ligne 2132
ORA-06512: à "SYS.WWV_DBMS_SQL_APEX_240200", ligne 822
ORA-06512: à "APEX_240200.WWV_FLOW_DYNAMIC_EXEC", ligne 1578
ORA-06512: à "APEX_240200.WWV_FLOW_DYNAMIC_EXEC", ligne 1668
ORA-06512: à "APEX_240200.WWV_FLOW_DYNAMIC_EXEC", ligne 1435
ORA-06512: à "APEX_240200.WWV_FLOW_CONDITIONS", ligne 350
error_statement:select count(*) from sys.dual where exists (Select 1 from dual WHERE TRUNC(CURRENT_DATE) BETWEEN :APP_DATE_OUVERTURE AND :APP_DATE_FERMETURE
Thank you.