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!

Little display problem in the code editor for Bind variables

Hi Apex developpers,

Under APEX 24.1 (in French) in the code editor I have a nice SQL command :

select sum(a.duree) "Durée", c.TACHE "Tâche"
from RH_ACTIVITE_EFFECTUEE a, RH_TACHE c
where a.TACHE_EFFECTUEE_ID = c.ID
and a.EFFECTUEE_LE between to_date (:P4_DU, 'DD/MM/YYYY') and TO_DATE (:P4_AU, 'DD/MM/YYYY')
group by c.tache
order by TACHE

When run, it displays a windows asking the values of the bind variables :P4_DU and P4_AU:

All fine. When I run again the SQL command, the windows shows strange characters instead of the dates:

Is it possible to repair this little problem ?

Best regards.

This post has been answered by Steve Muench-Oracle on Jun 30 2024
Jump to Answer
Comments
Post Details
Added on Jun 30 2024
2 comments
158 views