Error ORA-01722 in SQL issue

Asked By jessie k 40 points N/A Posted on - 06/13/2011

Good Evening!

Please provide me a solution to this problem.

I was performing some addition and subtraction from dates in the SQL server database while this error occurred. I have faced this error for the first time. As far as I understand, it may be caused because I was adding non-numeric values along with the dates and was subtracting alphanumeric values from the dates. But it's my need that I have to add and subtract in this way.

I don’t know how SQL operates all arithmetic operations, but still I want someone to sort this out so I can add the values and numeric values my way and can get the desired output of numeric values.

Don’t stress on my idea ,but just try to figure it out that what may be the actual cause of this error. My work is stopped and will start when someone out of you people guides me about the solution of this problem. Waiting for your kind response can you solve it?

Error encountered An error was encountered performing the requested Operation.

ORA-01722: invalid number

01722. 00000 – “ invalid number”

*Cause:

*Action:

Vendor code 1722 Error at line:1 Column:131

• Status: Open
• Question Views: 3307
• Answer Count: 2
• Vote Up 1 Vote Down

• Answer Accepted: Yes
• Question Category: MySQL Server

Best Answer by MaryScott

Go To Solution

Best Answer

Best Answer

Answered By MaryScott 0 points N/A #121605

Error ORA-01722 in SQL issue

Jessie,
ORA-01722: invalid number error message means that the process in converting a character string to a number was unsuccessful. It might be because the entered string was invalid. The entry should contain a numeric value to be considered as valid character.
 
The best solution is to verify the character strings entered in the function. It should contain numbers, decimal point, sign then try to enter again the operation. I hope everything will be fine at your end.

About MaryScott

Questions
0

Answers
4

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 06/15/2011
• Question Category: MySQL Server

Answered By Amber1 0 points N/A #121606

Error ORA-01722 in SQL issue

Dear Jessie, The ORA-01722 error main cause is wherever there is some conversion function is used in this case while converting some character string into numeric string. I will explain solution using an example. Please see the image below showing a SQL statement.

Here converting a string into numbers while “,” comma is not a number character that why this error occurred. Hope you understand the problem and will consider where you have gone mistakenly. If still problem persists please feel free to write me again. Will try to help you out with some other examples.

About Amber1

Questions
0

Answers
5

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 09/09/2011
• Question Category: MySQL Server