This discussion is archived
7 Replies Latest reply: Apr 26, 2013 6:26 AM by 1002371 RSS

Format Mask causing FRM-40209 Error.

1002371 Newbie
Currently Being Moderated
Hey experts,
I decided on my phone number field to use the format mask so that the phone number typed in would look like
1-888-123-4567 however if the user attempts to save the form and they typed less than 10 numbers I get a FRM-40309 error where it says it's not in the format 9"-"999"-"999"-"9999
I even attempted to create an on-error trigger to display an alert and end stop the action but unfortunately I do not know what exception to RAISE after creating the alert.

Any ideas?
The Oracle Peon...


  • Correct Answers - 10 points
  • Helpful Answers - 5 points