Home » RDBMS Server » Server Utilities » problem using sqlldr(2 Merged)
problem using sqlldr(2 Merged) [message #520287] Sat, 20 August 2011 10:08 Go to previous message
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


 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: import
Next Topic: Audit Select..
Goto Forum:
  


Current Time: Fri Mar 29 11:02:55 CDT 2024