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



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

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-06140: NETTCP: no such user

1 Answers  


ORA-22807: cannot resolve to a scalar type or a collection type

1 Answers  


ORA-21300: objects option not installed

1 Answers  


ORA-14151: invalid table partitioning method

1 Answers  


LPX-00250: invalid attribute declaration

1 Answers  






SQL*Loader-00915: Error closing cursor: [number]

1 Answers  


ORA-02202: no more tables permitted in this cluster

1 Answers  


ORA-01870: the intervals or datetimes are not mutually comparable

1 Answers  


ORA-02729: osncon: driver not in osntab

1 Answers  


ORA-13048: recursive SQL fetch error

1 Answers  


IMP-00078: Cannot translate FILE locator to "string" "string" in server character set

1 Answers  


DRG-13005: alt_value cannot be an NLS language name

1 Answers  


Categories