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 |
LETS NOT WAIT FOR OPPORTUNITY TO KNOCK OUR DOOR BUT WILL OPEN THE DOOR AND GRAB THE OPPORTUNITY.........BECAUSE OPPORTUNITY COMES ONCE IN THE LIFE TIME
Pages
Popular Posts
-
SENDING MAIL ON SUCCESSFUL REGISTRATION: This concept can be use in many places(NOW THIS MEANS MAIL....:) ) like sending mail on perfo...
Thursday, 22 August 2013
ORA-01722: invalid numbeR
Labels:
ORACLE TIPS AND ERRORS
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment