Solved

ora-01722 invalid number

Posted on 2002-05-06
6
1,245 Views
Last Modified: 2007-12-19
hi all,

I am currently installed an oracle with nls_lang setting to AMERICAN_AMERICA.WE8ISO8859P1 .  My computer regional seting is "English(United Kingdom)".

Sometimes but not always i get the following error:
ora-01722 invalid number

Is there any inonsistencies between these settings?
Any idea will be appreciated.
Thanks
0
Comment
Question by:camasuvi
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 19

Expert Comment

by:Jim Cakalic
ID: 6991481
There are a variety of scenarios in which ORA-01722 can occur. Given that the two locales (UK and US) are identical with respect to the characters that make up a valid number (digits, decimal point, sign, 'E'/'e' for scientific notation) it is unlikely that this is the cause of your problem.

More likely, there really is 'bad data' somewhere that results in the conversion raising the error. The Oracle FAQ reviews a number of the possible scenarios and suggests a resolution strategy for each. Review this if you haven't already done so.
    http://www.orafaq.com/error/ora-01722.htm

Best regards,
Jim Cakalic
0
 

Expert Comment

by:satyesh
ID: 6996108
>> if u r trying to update an oracle table, thru JDBC...    
>>> if u r trying to update a numerical value in the table using preparedstatement, make sure you are a compatible corresponding java object to update.
   column type java.sql.Types.NUMERIC -- use java.lang.BigDecimal
   column type java.sql.Types.INTEGER -- use java.lang.Integer
   column type java.sql.Types.BIGINT -- use java.lang.Long
   column type java.sql.Types.TINYINT -- use java.lang.Byte
   for SMALLINT -- java.lang.Short
   for REAL -- java.lang.Float
   for FLOAT -- java.lang.Float
   for DOUBLE -- java.lang.Double
     
0
 
LVL 19

Expert Comment

by:Jim Cakalic
ID: 7021874
Hi, camasuvi. Do you need more assistance with this question?
0
Transaction Monitoring Vs. Real User Monitoring

Synthetic Transaction Monitoring Vs. Real User Monitoring: When To Use Each Approach? In this article, we will discuss two major monitoring approaches: Synthetic Transaction and Real User Monitoring.

 
LVL 5

Expert Comment

by:vemul
ID: 7888134
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

- PAQ'ed and points NOT refunded

Please leave any comments here within the
next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

vemul
Cleanup Volunteer
0
 
LVL 19

Expert Comment

by:Jim Cakalic
ID: 7896197
OK.
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 7959690
Question placed in PAQ

Computer101
E-E Admin
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Java had always been an easily readable and understandable language.  Some relatively recent changes in the language seem to be changing this pretty fast, and anyone that had not seen any Java code for the last 5 years will possibly have issues unde…
Introduction This article is the last of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers our test design approach and then goes through a simple test case example, how …
Viewers will learn about the regular for loop in Java and how to use it. Definition: Break the for loop down into 3 parts: Syntax when using for loops: Example using a for loop:
This tutorial covers a practical example of lazy loading technique and early loading technique in a Singleton Design Pattern.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question