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!

Dynamically display the content of a calculated field in a form without submitting the page ?

Christian Pitet.Mar 24 2026

Hi,

Under , I have a form with several items. An item value is calculated from the values of from fields The Item name is p10_TOTAL.

The computation of this item is made by a PL/SQL expression:

((:P10_TARIF * NVL(:P10_NOMBRE_ADULTES, 1) + NVL(:P10_NOMBRE_ENFANTS, 0)) *
(to_date(:P10_DATE_FIN_RESERVATION, 'DD/MM/YYYY') - to_date(:P10_DATE_RESERVATION, 'DD/MM/YYYY'))
)  + (
   
   (to_date(:P10_DATE_FIN_RESERVATION, 'DD/MM/YYYY') - to_date(:P10_DATE_RESERVATION, 'DD/MM/YYYY')) 
   
   * :P10_VEHICULE * NVL(:P10_NOMBRE_VEHICULES,1))
+ (
   
   (to_date(:P10_DATE_FIN_RESERVATION, 'DD/MM/YYYY') - to_date(:P10_DATE_RESERVATION, 'DD/MM/YYYY')) 
   * NVL(:P10_ELECTRICITE, 1) + NVL(:P10_DON, 0))

But the item P10_TOTAL displays nothing:

I would like the item P10_TOTLA to display the result of this computation from the other items, without submitting the form.

Is it possible ?

Best regards.

Comments
Post Details
Added on Mar 24 2026
3 comments
228 views