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!

Why Oracle Apex does not apply format mask to item field?

GosforthApr 5 2021 — edited Apr 5 2021

In static content region I have number field - P10_SOMEFIELD.
I populate this field with
apex_util.set_session_state('P10_SOMEFIELD', l_something );
(l_something is number). I apply format mask ''999999999D9999999999', Appearance properties - does not work. I still have .9 for decimals. Should be '0.9'.
OK, I try another method. In PL/SQL i insert:
apex_util.set_session_state('P10_SOMEFIELD', TO_NUMBER(l_something,'999999999D9999999999'));
and remove format mask in field property - Appearance. Does not work.
What is wrong with that?

This post has been answered by fac586 on Apr 6 2021
Jump to Answer
Comments
Post Details
Added on Apr 5 2021
6 comments
5,573 views