- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- HELP!!!Oracle conversion characters
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-01-2001 03:30 PM
тАО08-01-2001 03:30 PM
I had been the error ORA-01722 - invalid number. If possible, how can i solve this without any changes in the programs?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-01-2001 09:32 PM
тАО08-01-2001 09:32 PM
Re: HELP!!!Oracle conversion characters
You should check the data, which were going to be converted. The character string, you wanted to convert, was not a valid numeric literal.
Check the data in hex format, if necessary.
Valid for this conversion :
only numbers, a sign, decimal point, character 'E' or 'e'
Rgds
Alexander M. Ermes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-02-2001 07:04 AM
тАО08-02-2001 07:04 AM
Re: HELP!!!Oracle conversion characters
I had a DB with LS_CHARACTERSET = WE8ISO8859P1 and LS_NCHAR_CHARACTERSET = WE8ISO8859P1; After migrate to another server/Oracle version (from 8.0.5 to 8.1.6) some aplications do not recognize some data. The msg I got is ORA-01722. My big problem is that I do not have the source code (in this moment) to correct. But i didn't understand that if I do not change de characterset, why I get this error...?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-02-2001 11:10 AM
тАО08-02-2001 11:10 AM
Re: HELP!!!Oracle conversion characters
What are you doing when you get this error? Are you importing data? Or maybe, is that data already in the database and an application is raising this error?
Unfortunately, there are very different solutions, depending on exactly what is causing the error. If you are getting this error from SQL loader, you should check the data to make sure that it is a valid number. If you are getting this error from an application, it could be that you are calling a procedure, trigger or someother statement that is expecting a number, but did not receive it.
I guess I'm just not convinced that the error is necessarily coming from the character set of the database.
If you have any more information, please let us know. I hope this was of some help to you.
Jared
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-03-2001 06:21 AM
тАО08-03-2001 06:21 AM
SolutionMy response will assume that your application that is trying to access the database resides on a windows NT and it is using ODBC connection. The problem may be related to this msorcl32.dll. If that is the case you may wanna upgrade service pack or you could look at this from microsoft website
http://support.microsoft.com/support/kb/articles/Q216/9/78.ASP
.
I would for sure try this in a development box first.