A recent question on the Oracle customer forum (SQL and PL/SQL) resulted in me rediscovering a note I wrote a few years ago about the validate_conversion() function and the "on conversion error" extension that appeared in 12c for conversion functions:
https://jonathanlewis.wordpress.com/2020/04/24/conversion-errors/

Comments

Posting Rules

  • Be respectful to others
  • No spam or self-promotion
  • Stay on topic
  • Follow Bluesky's terms of service