Skip to Main Content
Forums

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!

How to create a validation on number field.

Rahul385Jul 27 2012 — edited Jul 30 2012
Hello Experts,

My database table has a numeric column EMP_ID. I want to create a validation so that a user can only enter numeric value in this field on the Apex page.

I have tried to create validation Item/Column specified is numeric for item P2_EMP_ID.

But when I submit the page, I still get the error ORA-01722: invalid number.

How can I create a validation so that the ORA error is hidden from the end user and instead a custom message is displayed.

Thanks,
Rahul
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 27 2012
Added on Jul 27 2012
#apex-discussions
3 comments
1,113 views