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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Error during update field with format mask

FC60Nov 29 2016 — edited Nov 30 2016

Hi,

I have this error: ORA-06502: PL/SQL: numeric or value error: character to number conversion error

I created a validation for a numeric field with a format mask (FML999G999G999G999G990D00)

if ... and :P41_VAL_BUDGET > 0 ... then

when I create the new record I don't have errors (I don't have the $ symbol in my page), but when I reopen the record for update I have this error.

If I delete the format mask I don't have the error during update statement.

How can I do my validation to use the format mask?

Thanks for the help.

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 28 2016

Added on Nov 29 2016

#apex-discussions

6 comments

1,348 views