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
-
GET DATA FROM SQLITE AND MYSQL DATABASE Today we will see how to get data from sqlite database and mysql database . 1. DATA FROM...
-
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... -
PayPal Gateway Integration in ASP.NET Introduction If you are developing an ASP.NET web application and you require some payment ga... -
CREATE LOG FILE Yes the necessary Evil which only help us to study our error in more details and to ealisy understand when and why any...
-
ADD ROWS DYNAMICALLY IN GRIDVIEW THE DESIGN PAGE: <%@ Page Language="C#" AutoEventWireup="true" CodeFile=... -
EXCEL SHEET UPLOAD IN ORACLE DATABASE WITH DATE CONDITIONS Hello Friends Today we will see how to upload excel sheet in oracle databas...
-
I have been in this industry(IT) not so LONG enough But still I can count the faces with such bad /funcky look, when every developer and D...
Thursday, 22 August 2013
ORA-01722: invalid numbeR
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment