Solved

ora-01722 invalid number

Posted on 2002-05-06
6
1,228 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
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
Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

 
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

ScreenConnect 6.0 Free Trial

Explore all the enhancements in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI, app configurations and chat acknowledgement to improve customer engagement!

Question has a verified solution.

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

INTRODUCTION Working with files is a moderately common task in Java.  For most projects hard coding the file names, using parameters in configuration files, or using command-line arguments is sufficient.   However, when your application has vi…
Introduction This article is the first of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article explains our test automation goals. Then rationale is given for the tools we use to a…
Viewers will learn about the different types of variables in Java and how to declare them. Decide the type of variable desired: Put the keyword corresponding to the type of variable in front of the variable name: Use the equal sign to assign a v…
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …

809 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