oracle加载number,sqlldr导入number类型报错！

load data infile '/myfile/xq/cp4-1.csv'

into table tmp4

truncate

FIELDS TERMINATED BY ','

TRAILING NULLCOLS

(

area_code,

accs_nbr "trim(:accs_nbr)",

code "trim(:code)",

comments "trim(:comments)",

fee "to_number(:fee)"

)

more cp.log

Number to load: ALL

Number to skip: 0

Errors allowed: 50

Bind array:     64 rows, maximum of 256000 bytes

Continuation:    none specified

Path used:      Conventional

Table COPY_CARD_TMP3, loaded from every logical record.

Insert option in effect for this table: TRUNCATE

TRAILING NULLCOLS option in effect

Column Name                  Position   Len  Term Encl Datatype

------------------------------ ---------- ----- ---- ---- ---------------------

AREA_CODE                           FIRST     *   ,       CHARACTER

ACCS_NBR                             NEXT     *   ,       CHARACTER

SQL string for column : "trim(:accs_nbr)"

CODE                                 NEXT     *   ,       CHARACTER

SQL string for column : "trim(:code)"

COMMENTS                             NEXT     *   ,       CHARACTER

SQL string for column : "trim(:comments)"

FEE                                  NEXT     *   ,       CHARACTER

SQL string for column : "to_number(:fee)"

Record 1: Rejected - Error on table COPY_CARD_TMP3, column FEE.

ORA-01722: invalid number

Record 2: Rejected - Error on table COPY_CARD_TMP3, column FEE.

[本帖最后由 alfred1980 于 2010-3-12 16:21 编辑]