invalid number

Oracle failed to convert a character string to a number. Usually caused by non-numeric characters in a column or expression expected to be numeric. Inspect the data and use TO_NUMBER() with a format mask, or REGEXP_LIKE to validate before conversion.