Seeking solution to Data Integration.... where date filed may contain character.
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?
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
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')