Hi,
Under apex 24, I try to set the value of an item (P10_DATE_FIN_RESERVATION) type date, based on the change of another item type number (P10_NUITES) with a DA. This is the SQL of the DA (on modification of the item P10_DATE_RESERVATION):
update ve_reservation set DATE_FIN_RESERVATION = (TO_DATE (:P10_DATE_RESERVATION, 'DD/MM/YYYY') + :P10_NUITES)
where UPPER(USER_NAME) = UPPER(:APP_USER) and DATE_RESERVATION = :P10_DATE_RESERVATION ;
The elements to submit are P10_DATE_RESERVATION, P10_NUITES, APP_USER. This occurs I think because the column P10_DATE_RESERVATION is on the server-side and is not on session value at this time.