Oracle DBA, How To, Error, Cause and Action

ORA-09820: Conversion of class string to numeric representation failed.

ORA-09820: Conversion of class string to numeric representation failed.




Cause: ORACLE was unable to convert a class string to a number because all of the characters in the string were not numeric.




Action: Change the string to be either all numbers or all non-numeric characters and repeat the conversion.

No comments:

Post a Comment

Thanks for your comment.