ORA-01722: Invalid Number mostly occurs in runtime. There are some errors in programming that may generate ORA-01722: Invalid Number error. Let me present this formally.
Cause:
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.
Action:
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
Experience:
I got the error in runtime when I assigned numeric value to a varchar2 parameter passed to a package. There may other so many possible reasons as discussed above.
At the end, you may also like to read on implementing object relational database features in oracle like nested table, inheritance, collection array, member function etc.
Happy Programming!
Subscribe to:
Post Comments (Atom)
Popular Posts
-
Most of the times programmers fill the DataTable from database. This action fills the schema of the database table into the DataTable . We ...
-
I have found much tricks in different tutorials and forums on opening new window in asp.net web page, using JavaScript, jquery etc. Here I h...
-
The asp.net Eval() and Bind() expressions are heavily used in asp.net GridView and DetailsView data bound controls. The difference between ...
-
I have oracle database installed in my computer. My Operating system is XP. I wrote an application in asp.net. It connected to oracle databa... -
Last time I got the following error: HTTP Error 500.19 - Internal Server Error The requested page cannot be accessed because the related ... -
Last time we talked about Refreshing the parent page from child window in asp.net using javascript . This technique is useful in many scenar... -
We do have a folder (and a number of sub folders) with a number of various files in those folders (and sub folders). Now we do need to list ... -
In this post, I am explaining the button click functionality on key press in a textbox. I am using javascript to link the input textbox and ... -
Much often we open child windows from parent web page . In the child page we perform some activities, and later close the window. At the ver...
-
The default behaviour of asp.net gridview is that it hides both Gridview header and footer when no data is present. You can note the absence...
0 comments:
Post a Comment
Hope you liked this post. You can leave your message or you can put your valuable suggestions on this post here. Thanks for the sharing and cooperation!