title: Oracle loader with Skip Option
body: <p>Here i tell the loader to skip the 2 first lines of the file.csv
  but it doesnt skip the lines. it still tell me that he cant skip the 2 lines. </p>
  
  <p><strong>translated error message:</strong></p>
  
  <p><strong><em>line 1: skiped - all columns are null</em></strong></p>
  
  <p><strong><em>line 2: refused - Error in table test_table, column id.</em></strong></p>
  
  <p><strong><em>ORA-01722: invalid number.</em></strong></p>
  
  <p>Here the loader try to load the line 2 into the test_table but failed because of the column "COMP" from the line 2.</p>
  
  <p>So can someone tell what i m doing wrong here. Thx for help</p>
  
  <h2>control_file.ctl</h2>
  
  <pre><code>OPTIONS (SKIP = 2)
  Load truncate
  into table test_table
  fields terminated by ';' 
  trailing nullcols
  (
    field1 filler,
    system filler,
    id,
    Firstname,
    Lastname,
    field5 filler,
    field6 filler,
    status,
    newid
   )
  </code></pre>
  
  <p>---Table to be loaded---------------</p>
  
  <pre><code> CREATE TABLE test_table(
         id NUMBER(30),  
     Firstname VARCHAR2(50),
     Lastname VARCHAR2(50),
     status NUMBER(1),
     newid VARCHAR2(50)
    );
  </code></pre>
  
  <p>------file.csv------------------------</p>
  
  <pre><code>"1";"1";"BG3784";"1233";"2018-09-29+02:00";"07:51:12.427+02:00"
  "2";"COMP";;"";
  "3";"TESTSERVER";1;"John";"Donald";;;1;"22117"
  "3";"TESTSERVER";2;"Toto";"Smith";;;0;"22969"
  "3";"TESTSERVER";3;"Leonardo";"Pitt";;;;"81247"
  "3";"TESTSERVER";4;"Micheal";"Bron";;;;"51149"
  </code></pre>