2. Error
Message: ORA-01722:
|
invalid numbeR |
Cause of Error: |
The attempted conversion of a character string to a
number failed because the character string was not a valid numeric literal.
Only numeric fields or character fields containing numeric data may be used
in arithmetic functions or expressions. Only numeric fields may be added to
or subtracted from dates.
|
Resolution: |
Check the character strings in the function or expression. Check that they contain only numbers, a sign, a decimal point, and the character "E" or "e" and retry the operation |
Popular Posts
-
ACTIVATES AND ADD ARTICLES Today we will see how to make article page and to shoe on the webpage only after activation (this can be do... -
Using Google Co-op's Custom Search Engine Using google free api you can add a search Engine for your own website ,just need to h... -
TWO SIMPLE STEPS FOR Disabling THE BUTTON ON SUBMIT It is always required for the application to disable the submit /button button unt...
-
Most common mistakes C# developers make While working with (young) C# Programmers I’ve noticed that some mistakes are being repeated ...
-
1.DROP TABLE COMMAND/PURGE RECYCEBIN Get droped table BACK VIA FLASHBACK The Oracle DROP command is used to remove database object...
-
SQL INJECTION and Cross-Site Script ing Attacks What is SQL Injection and Cross-Site Script ing Cross-Site Script ing ... -
How to understand, use and implement captcha to protect your web site against spam and form spammingHow to understand, use and implement captcha to protect your web site against spam and form spamming. ( The FREE anti-bot service t...
Thursday, 22 August 2013
ORA-01722: invalid numbeR
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment