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
-
SHOW YOU TUBE VIDEOS CATEGORY WISE ON YOUR WEBSITE Its quit simple and easy if we look on common concepts of asp.net and say progra...
-
DYNAMICALLY ADDING MASTER PAGES. Conditions occurs when we have several master page and need to add on certains pahes at specific cond... -
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...
-
Difference Between Get And Post method in ASP.Net So many new programmer are confused about post and get method for send the data. In th...
-
INSERT ROWS IN ORACLE WHILE CONCATENATING ROWS IN EXCEL USING CONCATINATION WE can simply insert the excel data into oracle while maki... -
How do database indexes work/How to Create database index Let’s start out our tutorial and explanation of why you would need a databas...
-
SQL Server Error Messages - Msg 205 Error Message: Server: Msg 205, Level 16, State 1, Line 2 All queries in an SQL state...
Thursday, 22 August 2013
ORA-01722: invalid numbeR
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment