Solved

ora-01722 invalid number

Posted on 2002-05-06
6
1,238 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
type mismatch (Object[] to double[] 4 41
servlet web applications   metadata-complete="true" or false 3 201
Bot application - advice 3 63
jsp error 6 47
This was posted to the Netbeans forum a Feb, 2010 and I also sent it to Verisign. Who didn't help much in my struggles to get my application signed. ------------------------- Start The idea here is to target your cell phones with the correct…
In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
Viewers learn about the “for” loop and how it works in Java. By comparing it to the while loop learned before, viewers can make the transition easily. You will learn about the formatting of the for loop as we write a program that prints even numbers…
This tutorial will introduce the viewer to VisualVM for the Java platform application. This video explains an example program and covers the Overview, Monitor, and Heap Dump tabs.

726 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