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-30121: 'string' is not an allowable value for 'string'

1 Answers   CTS,


ORA-02397: exceeded PRIVATE_SGA limit, you are being logged off

1 Answers  


ORA-14281: CHECK constraint mismatch in ALTER TABLE EXCHANGE SUBPARTITION

1 Answers  


ORA-09930: LUB of two labels is invalid

1 Answers  


ORA-06112: NETTCP: invalid buffer size

1 Answers  






ORA-39057: invalid worker request string for string jobs.

1 Answers  


RMAN-00579: SCRIPT cannot be used with CMDFILE

1 Answers  


ORA-25266: didnt try to dequeue by message id. with the signature

1 Answers  


ORA-29951: warning in the execution of ODCIINDEXSPLITPARTITION routine

1 Answers  


ORA-01667: cannot add any more tablespaces: limit of string exceeded

1 Answers  


ORA-12548: TNS:incomplete read or write

1 Answers  


PLS-00216: NUMBER precision constraint must be in range (1 .. 38)

1 Answers  


Categories