Geeks Talk

Prepare for your Next Interview




ORA-01722 Error in updating records

This is a discussion on ORA-01722 Error in updating records within the Oracle forums, part of the Databases category; I developed a project for a chemical company , VB as front end and Oracle 9i as back end. I am getting an error ORA-01722, when i am updating records ...


Go Back   Geeks Talk > Databases > Oracle

Register FAQ Members List Calendar Mark Forums Read
  #1 (permalink)  
Old 12-26-2007
Junior Member
 
Join Date: Jun 2007
Location: HYDERABAD
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
sriram_tvs is on a distinguished road
ORA-01722 Error in updating records

I developed a project for a chemical company , VB as front end and Oracle 9i as back end. I am getting an error ORA-01722, when i am updating records from client computer which is working with Windows 98 OS. where as i am not getting any error when i am updating records in client mechines which are working with Windows Xp.

help me to solve my problem.
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 12-27-2007
Junior Member
 
Join Date: Jun 2007
Location: HYDERABAD
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
sriram_tvs is on a distinguished road
Re: ORA-01722 Error in updating records

help me to come solve the problem
Reply With Quote
  #3 (permalink)  
Old 12-31-2007
Moderator
 
Join Date: Jun 2007
Location: Bangalore,India
Posts: 1,330
Thanks: 7
Thanked 119 Times in 107 Posts
debasisdas will become famous soon enoughdebasisdas will become famous soon enough
Re: ORA-01722 Error in updating records

ORA-01722: invalid number
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.
Reply With Quote
Reply

  Geeks Talk > Databases > Oracle


Thread Tools
Display Modes


Similar Threads

Thread Thread Starter Forum Replies Last Post
Inserting instead of updating krishnaindia2007 Oracle 4 10-15-2007 07:38 AM
Cyclic Updating JobHelper Oracle 2 10-13-2007 04:06 AM
Error while inserting or updating Geek_Guest SQL 1 09-09-2007 10:28 AM
Updating Java version Geek_Guest Java 1 04-16-2007 08:13 AM
Where are the error records located Geek_Guest Oracle Apps 0 03-01-2007 08:44 PM


All times are GMT -4. The time now is 02:16 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Copyright © 2008 GeekInterview.com. All Rights Reserved