problem using sqlldr(2 Merged) [message #520287] |
Sat, 20 August 2011 10:08 |
|
p40l3tt0
Messages: 9 Registered: August 2011
|
Junior Member |
|
|
Good Morning,
i have the problem with sqlldr.
This is the table:
Name Null? Type
----------------------------------------- -------- ----------------------------
A NUMBER(9)
B NUMBER(9)
C NUMBER(9)
This is the ctl file:
LOAD DATA
INFILE './PROVA.txt'
REPLACE
INTO TABLE prova
FIELDS TERMINATED BY "\t"
OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(
A,
B,
C
)
This is the log file:
Record 1: Rejected - Error on table PROVA, column A.
ORA-01722: numero non valido
Record 2: Rejected - Error on table PROVA, column A.
ORA-01722: numero non valido
Record 3: Rejected - Error on table PROVA, column A.
ORA-01722: numero non valido
Help me!!! I'm crazy for error ORA-01722
Thank you very much!!
Bye bye
|
|
|
|
|
Re: problem using sqlldr(2 Merged) [message #520292 is a reply to message #520291] |
Sat, 20 August 2011 10:46 |
John Watson
Messages: 8962 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Yes, there is something missing: what is the data that you are trying to load? It is, presumably, that which is causing the error. (And please don't forget to read those guidelines)
|
|
|
|
|
|
|
|
|
|
|
Re: problem using sqlldr(2 Merged) [message #520306 is a reply to message #520305] |
Sat, 20 August 2011 13:23 |
John Watson
Messages: 8962 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
I think we can conclude that your data file does not have tabs.
And I think you have had enough guidance from me and BS on problem solving technique that you should be able to fix this next problem yourself.
|
|
|
|
|
Re: problem using sqlldr(2 Merged) [message #520315 is a reply to message #520312] |
Sun, 21 August 2011 02:52 |
John Watson
Messages: 8962 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
I'm not going to call you "stupid", because that would break the rules of the forum. But I am going to quote an Eglish proverb: "You can lead a horse to water, but you can't make it drink".
You have already been given a perfectly worked example of how to investigate this type of problem. You have:
1. An error message
2. A table definition
3. A data file definition
4. A data file
So consider these components. How could a mismatch between 2, 3, and 4 cause 1?
|
|
|
|
|
|
Re: problem using sqlldr(2 Merged) [message #520330 is a reply to message #520328] |
Sun, 21 August 2011 10:12 |
|
BlackSwan
Messages: 26766 Registered: January 2009 Location: SoCal
|
Senior Member |
|
|
>But why the tab and space consider them equal?
>FIELDS TERMINATED BY WHITESPACE
WHITESPACE includes BOTH Horizontal Tab, CHR(9), and space, CHR(32), characters.
if sqlldr is to treat them differently, do NOT use keyword WHITESPACE!
|
|
|