| ankur |
Posted: Nov 29, 2007 12:35:20 AM |
Total Post: 59
Joined: Nov, 2006
|
Hi
I am Trying to insert a value (ROUND((CCE_MTM/1000000),3) as CCE_MTM)
into target column of type number .
But it is giving me error ORA-01426: numeric overflow
Can anybody tell me the solution. |
|
|
 Murtuja |
| Posted: Nov 29, 2007 01:32:54 AM |  |
|
Total Post: 857
Joined: Jan, 2006
|
What is data_type and data_length of CCE_MTM column?
|
|
|
|
|
| ankur |
| Posted: Nov 29, 2007 01:37:41 AM | |
|
Total Post: 59
Joined: Nov, 2006
|
|
|
|
|
| Murtuja |
| Posted: Nov 29, 2007 05:39:16 AM | |
|
Total Post: 857
Joined: Jan, 2006
|
Ankur,
I was not getting any error in my test.
create table bigno (nr Number(20,3))
insert into bigno values (12345678912345678)
I am using Oracle 10.2.0.3.
|
|
|
|
|
| Mohammed Taj |
| Posted: Nov 29, 2007 07:03:15 AM | |
|
Total Post: 746
Joined: Jul, 2007
|
@op,
Error:
ORA-01426: numeric overflow
Cause:
You tried to evaluate an expression that resulted in a numeric overflow (or underflow).
Action:
The options to resolve this Oracle error are:
Re-write your expression using fewer operands.
Make sure that your expression does not evaluate to infinity.
@Murtuja,
Did you understand OP question...?
he is not getting this error ORA-01438 according your demostration.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
