title: Wait...are types NUMBER and VARCHAR2 no longer allowed in sqlldr?
body: <p>Bizarre syntax error:</p>
  
  <pre><code>LOAD DATA
  INFILE z.dat
  INTO TABLE table1
  REPLACE
  FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
  TRAILING NULLCOLS
  (
  
      COL1 NUMBER(10), 
      COL2  
  )
  </code></pre>
  
  <p>Is yielding:</p>
  
  <pre><code>Expecting "," or ")", found "NUMBER".
          COL1 NUMBER(10),
        ^
  </code></pre>
  
  <p>Works with type DECIMAL. Backend - Oracle12c. OS - RHEL.
  Did I miss the memo?</p>
  
  <p>SQL*Loader: Release 12.2.0.1.0 </p>
  
  <p>Even more: would not allow type VARCHAR2, but VARCHAR is ok. Has anyone encountered this behavior/bug?</p>
  
  <p>This comes through:</p>
  
  <pre><code>LOAD DATA
  INFILE 'z.dat'
  INTO TABLE table1
  (
  col1 VARCHAR(10), 
  col2 INTEGER
  )
  </code></pre>
  
  <p>This - does not:</p>
  
  <pre><code>LOAD DATA
  INFILE 'z.dat'
  INTO TABLE table1
  (
  col1 VARCHAR2(10), 
  col2 INTEGER
  )
  </code></pre>
  
  <p>SQL*Loader-350: Syntax error at line 7.
  Expecting valid column specification, "," or ")", found "VARCHAR2".
  col1 VARCHAR2(10),
        ^</p>
  
  <p>The funkiest fact is that I was even using an example from Oracle's docs (albeit 10g), and it still won't get through.</p>