|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
September 7th, 2005, 01:06 PM
|
|||
|
|||
|
ORA-01722: invalid number...how to correct?
Hi,
I'm trying to load data from SQL Loader, and it keeps puking on the same column, giving me the invalid number error, but don't understand why. Here's my control file: Code:
options (skip=1) load data infile image_program.csv append into table image_program ( image_program_id TERMINATED BY ',', image_id TERMINATED BY ',', program_id TERMINATED BY ',' ) Here's my data file: Code:
image_program_id,image_id,program_id 10,10,1 11,11,1 12,12,1 13,13,1 14,14,1 15,15,1 The data is really simple numbers, all other control files and data files loaded fine, even the parent tables of this one? Any help is appreciated. -m
|
|
#2
September 7th, 2005, 04:15 PM
|
|||
|
|||
|
This may sound stupid, but did you check that the zeroes in the file are all character "zero" and not the character Oh?
|
|
#3
September 7th, 2005, 04:19 PM
|
|||
|
|||
|
Jim,
at this point nothing sounds stupid to me, since I am at a loss for an answer to this one. And yes, I double-checked that they're real zero's too. The funny thing is that I can manually insert a record through sqlplus using the first row of data; 10,10,1, but still no luck using the loader. Don't want to have to resort to loading 300+ records line by line ;( thx, mike
|
|
#4
September 9th, 2005, 01:49 PM
|
|||
|
|||
|
log?
Code:
sqlldr $UID/$PSWD control=extract_load.ctl errors=200 log=extract.log Look at the error information in extract.log
|
|
| Viewing: Dev Shed Forums > Databases > Oracle Development > ORA-01722: invalid number...how to correct? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
