Number (10,5) [message #291441] |
Fri, 04 January 2008 04:09 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
vanathi
Messages: 74 Registered: December 2007 Location: India
|
Member |
|
|
Hi,
I declared a column with Number(10,5).
While loading data from csv to oracle, the sql loader rejects
the data 16089.38.
Please advice.
|
|
|
|
|
|
Re: Number (10,5) [message #291599 is a reply to message #291598] |
Sat, 05 January 2008 05:54 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
vanathi
Messages: 74 Registered: December 2007 Location: India
|
Member |
|
|
"Record 23922: Rejected - Error on table PERFCORE3, column RETURNAFTERFEEIRR.
ORA-01438: value larger than specified precision allowed for this column"
This the log file error.
|
|
|
|
|
|
Re: Number (10,5) [message #291604 is a reply to message #291603] |
Sat, 05 January 2008 07:00 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
vanathi
Messages: 74 Registered: December 2007 Location: India
|
Member |
|
|
Sample rejected data
en017048,N7C006103,e,02282002,01022008,220849.73,12.49,220849.73,12.49,11302007,11302007
the control file is attached.
-
Attachment: ctl.txt
(Size: 0.72KB, Downloaded 1233 times)
|
|
|
|
|
Re: Number (10,5) [message #291609 is a reply to message #291444] |
Sat, 05 January 2008 07:28 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
vanathi
Messages: 74 Registered: December 2007 Location: India
|
Member |
|
|
Yes. I understood.
Michel Cadot wrote on Fri, 04 January 2008 15:58 |
SQL> create table t (col number(10,5));
Table created.
SQL> insert into t values(16089.38);
1 row created.
Your analysis is wrong.
Regards
Michel
|
But I can't understand this.
|
|
|
Re: Number (10,5) [message #291611 is a reply to message #291609] |
Sat, 05 January 2008 07:32 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote: | But I can't understand this.
|
You said:
Quote: | While loading data from csv to oracle, the sql loader rejects the data 16089.38.
|
And I showed you this is wrong and actually it was wrong as the bad data was 220849.73 and not 16089.38 (which is a correct one).
Regards
Michel
[Updated on: Sat, 05 January 2008 07:32] Report message to a moderator
|
|
|
|