You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Received Response
34
Views
3
Comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!