Seeking solution to Data Integration.... where date filed may contain character.

Summary:

Working on data integration and I'm running into an issue where the Date field may contain characters throwing the error "ORA-00911: invalid characters".

Has anyone run into this before and does anyone know of a workaround?

Content (required):

Version (include the version you are using, if applicable):

23.09.68

Code Snippet (add any code snippets that support your topic, if applicable):

CASE

WHEN VALIDATE_CONVERSION(UD2 AS DATE) <> 1 THEN ‘IGNORE’

WHEN UD2 is NULL THEN 'IGNORE'

ELSE TO_CHAR(TO_DATE(UD2, 'yyyymmdd'),'dd-MON-yyyy')

END