sqlloader

Data file: treatmentreply_845.info
00001     ,01-Jan-2001,3, ,  ,           ,25-Jul-2007,0,han,han 

ctl file: treatmentreply_845.ctl
LOAD DATA
INFILE './datfile/treatmentreply_845.info' BADFILE './datfile/treatmentreply_845.bad' DISCARDFILE './datfile/treatmentreply_845.dis'
INSERT
INTO TABLE cnc.treatment
(
studyid POSITION (1:10),
tformdate POSITION (12:22),
part_decno POSITION (24),
medium_id POSITION (26),
end_inmonths POSITION (28:29),
contactdate POSITION (31:42),
entrydate POSITION (44:55),
sendmedium_yn POSITION (57))
INTO TABLE cnc.participant
(
study_id POSITION (1:10),name POSITION(59:61), surname POSITION(63:65))


Log file:
SQL*Loader: Release 7.1.6.2.0 - Production on Wed Jul 25 17:44:51 2007

Copyright (c) Oracle Corporation 1979, 1994.  All rights reserved.

Control File:   ./datfile/treatmentreply_845.ctl
Data File:      ./datfile/treatmentreply_845.info
  Bad File:     ./datfile/treatmentreply_845.bad
  Discard File: ./datfile/treatmentreply_845.dis 
 (Allow all discards)

Number to load: ALL
Number to skip: 0
Errors allowed: 2000
Bind array:     64 rows, maximum of 65536 bytes
Continuation:    none specified
Path used:      Conventional
Silent options: FEEDBACK

Table CNC.TREATMENT, loaded from every logical record.
Insert option in effect for this table: INSERT

   Column Name                  Position   Len  Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
STUDYID                              1:10    10           CHARACTER            
TFORMDATE                           12:22    11           CHARACTER            
PART_DECNO                             24     1           CHARACTER            
MEDIUM_ID                              26     1           CHARACTER            
END_INMONTHS                        28:29     2           CHARACTER            
CONTACTDATE                         31:42    12           CHARACTER            
ENTRYDATE                           44:55    12           CHARACTER            
SENDMEDIUM_YN                          57     1           CHARACTER            

Table CNC.PARTICIPANT, loaded from every logical record.
Insert option in effect for this table: INSERT

   Column Name                  Position   Len  Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
STUDY_ID                             1:10    10           CHARACTER            
NAME                                59:61     3           CHARACTER            
SURNAME                             63:65     3           CHARACTER            

Record 1: Rejected - Error on table CNC.TREATMENT, column CONTACTDATE.
ORA-01858: a non-numeric character was found where a numeric was expected


Table CNC.TREATMENT:
  0 Rows successfully loaded.
  1 Row not loaded due to data errors.
  0 Rows not loaded because all WHEN clauses were failed.
  0 Rows not loaded because all fields were null.


Table CNC.PARTICIPANT:
  0 Rows successfully loaded.
  1 Row not loaded due to data errors.
  0 Rows not loaded because all WHEN clauses were failed.
  0 Rows not loaded because all fields were null.


Space allocated for bind array:                   6656 bytes(64 rows)
Space allocated for memory besides bind array:    83496 bytes

Total logical records skipped:          0
Total logical records read:             1
Total logical records rejected:         1
Total logical records discarded:        0

Run began on Wed Jul 25 17:44:51 2007
Run ended on Wed Jul 25 17:44:51 2007

Elapsed time was:     00:00:00.38
CPU time was:         00:00:00.01