title: Whats wrong with this Oracle CTL File or data?
body: <p>My data is this:</p>
  
  <pre><code>ID,SCORE_DATE,TYPE,SCORE,RAW_SCORE,RANK
  A1234,2012-09-05 23:59:59,FOOTBALL_TEAM_MIDDLE_AND_OLD_1234,10,0.123,1
  A5678,2012-09-05 23:59:59,FOOTBALL_TEAM_MIDDLE_AND_OLD_1234,20,0.456,2
  </code></pre>
  
  <p>CTL FILE:</p>
  
  <pre><code>load data           
  infile 'E:\Data\Sample.csv'
  badfile 'E:\Data\Sample.bad'
  APPEND into table TABLE1    
  fields terminated by "," optionally enclosed by '"'
  TRAILING NULLCOLS               
  (   
   DRIVER,
   STARTDTE "to_date(SUBSTR(:STARTDTE,1,10),'YYYY-MM-DD') - 27",
   TYPE  CONSTANT 'FOOTBALL',
   SCORE   ,
   RANKSCORE ":SCORE",
   RANK    ,
   ENDDTE "to_date(SUBSTR(:STARTDTE,1,10),'YYYY-MM-DD')",
   LOADDT     "sysdate"
  )
  </code></pre>
  
  <p>Here is my table structure:</p>
  
  <pre><code>CREATE TABLE "TABLE1"
    (
      "DRIVER" VARCHAR2(50 BYTE),
      "STARTDTE" DATE,
      "SCORE"           NUMBER,
      "ENDDTE" DATE,
      "TYPE" VARCHAR2(20 BYTE),
      "RANK"       NUMBER,
      "RANKSCORE"  NUMBER,
      "LOADDT"     VARCHAR2(20 BYTE)
    );
  </code></pre>
  
  <p>I am getting an error message for every row loaded:
  Record 3: Rejected - Error on table TABLE1, column SCORE.
  ORA-01722: invalid number</p>
  
  <p>Whats wrong?</p>