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

IMP-00046: using FILESIZE value from export file of string

1 Answers  


ORA-01776: cannot modify more than one base table through a join view

1 Answers  


ORA-29815: object being associated is not present

1 Answers  


ORA-14459: missing GLOBAL keyword

2 Answers  


SQL*Loader-00269: Null string not allowed as clause comparison text.

1 Answers  


SQL*Loader-00802: numeric EXTERNAL with DEFAULTIF clause not supported by External Table

1 Answers  


ORA-06510: PL/SQL: unhandled user-defined exception

1 Answers  


RMAN-06010: error while looking up datafile: string

1 Answers  


PCC-02305: illegal mixing of new and old style C function declarations

1 Answers  


ORA-02260: table can have only one primary key

1 Answers  


ORA-30563: outer join operator (+) not allowed in select-list

1 Answers  


RMAN-06106: this command requires that target database be mounted

1 Answers  


Categories