Solved

ORA-1722

Posted on 2011-02-21
6
901 Views
Last Modified: 2012-05-11
I insert or update  table this error message generated.

Example


SQL> select to_number('34,33') from dual;

TO_NUMBER('34,33')
------------------
             34,33

Bu update this column x number(7,2) value is 3433.

update y
set x=to_number('34,33');

after this statement

x=3433



0
Comment
Question by:venomx_
6 Comments
 
LVL 28

Expert Comment

by:Naveen Kumar
ID: 34941068
is update or insert or select giving the error for you ?
0
 
LVL 12

Expert Comment

by:enachemc
ID: 34941181
decimal point is, as the name implies, the point
0
 
LVL 28

Expert Comment

by:Naveen Kumar
ID: 34941199
i am yet to understand what is your issue with the update or select ?
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 34941971
please check your setting of NLS_NUMERIC_CHARACTERS:
http://www.cs.umbc.edu/portal/help/oracle8/server.815/a67789/ch2.htm#95402

it is likely defining the "." as decimal, and "," as thousand separator.

0
 
LVL 5

Expert Comment

by:jaiminpsoni
ID: 34941979
Check the session parameters NLS_NUMERIC_CHARACTERS.

It may be the case that you are using ',' as a group seperator.

What is the output of following? (Need to to login with sysdba privilege)

select * from nls_database_parameters where parameter like '%NUMERIC%';
select * from nls_session_parameters where parameter like '%NUMERIC%';
select * from nls_instance_parameters where parameter like '%NUMERIC%';

Are you running both the statements in different sessions? Please confirm.

Thanks,
Jaimin Soni
0
 
LVL 5

Expert Comment

by:jaiminpsoni
ID: 34942038
Also, are you getting error ORA-1722 when you update?

In that case update will fail anyways.

What is the value of x before the update? Is it 3433?

Please confirm...
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to connect SQL Server from my Oracle database? 11 131
dbms_crypto.decrypt   errors out 6 33
create a nested synonym 4 28
join actual table rows based on the column 25 21
Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

839 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