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!

Format mask error on saving page item to database

VS121May 8 2023

Hi ,

I am on APEX 22.2 Cloud and am trying to displays numeric fields with format mask to show thousand separator and $. However clicking save lands me in a invalid number error.

  • I applied format mask to numeric field fetched from database

  • Then while updating back to db, I do the to_number(:P21_FIELD, ‘FML999G999G999G999G999G999G990’) but then I run into the invalid number error.

Your inputs appreciated!

Thank you

Comments
Post Details
Added on May 8 2023
4 comments
737 views