This may occur while inserting/updating in number field is SQL. ORA-01722 exception occurs when we explicitly or simplicity try to convert a character string to a number. ![]() Check that they contain only numbers, a sign, a decimal point, and the character "E" or "e" and retry the operation. Only numeric fields may be added to or subtracted from dates.Īction: Check the character strings in the function or expression. ![]() Only numeric fields or character fields containing numeric data may be used in arithmetic functions or expressions. ![]() Cause: The attempted conversion of a character string to a number failed because the character string was not a valid numeric literal.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |