APEX

Hello everyone,

I'm using a simple application and in one field, i have a ' is numeric ' validation on a text field item.

Everything works fine except that when i enter a space ' ' , the validation does not stop the request and i end up with

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

I tried using Regex with something like : ^\d+$ and the space was still considered valid.
I know i can TRIM every single numeric field.. however, i was wondering if there was a more " elegant " solution and, most importantly, one i could apply to an entire workspace.

Thanks, Will

EDIT :
I am running APEX 3.0.1

Message was edited by:
user635738