Prior to 12.2 validating dates and numbers was a bit of a pain as you had to write your own custom PL/SQL function. OOS-Utils has a quick solution to this issue and I recommend using
If you’re using Oracle 12.2 or above you can (and should) use
validation_conversion instead. Here are some examples of how to use it along with results:
validate_conversion will return
1 for valid conversions and
0 for invalid conversions.
Note: in the next release of OOS Utils, the validation functions will use
validate_conversion if your database is 12.2 or older internally.