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
-
EXPORT EXCEL SHEET DATA IN ORACLE VIA SQL-DEVELOPER Its quite easy task ..you just need to build the table in database according to ...
-
1. Error Message: O RA-01839: date not valid for month specified Cause of Error You tried to enter a date value, but you specified an...
-
SIMPLE OWNED CAPTCHA TO FOREPLAY BOTS........... Here is the code for adding a simple captcha in your aspx code rather than using any t... -
CREATE FILE DIRECTORY AT PATH OTHER THAN YOUR APPLICATION PATH Sometime when you host your application in specific director then you nee...
-
YES SOmetimes the simple looking retrival becomes so headache that you douth your capabilities.The simple retrival of the data from databa...
-
ATTRACTIVE LOGIN PAGE WITH JQUERY THE DESIGN PAGE: 1. JqueryLoginPage <% @ Page Language ="C#" AutoEventWireup =... -
SIMPLE PROGRAM TO CHECK THE VARIOUS CONSTRAINT REQUIRED AT FOR FILE UPLOAD THE DESIGN PAGE: <%@ Page Language="C#" ...
Thursday, 22 August 2013
ORA-01722: invalid numbeR
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment