7 Replies Latest reply: Apr 26, 2013 8:26 AM by 1002371 RSS

    Format Mask causing FRM-40209 Error.

      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...