title: Oracle error:- LRM-00116: syntax error at 'control' following '='
body: <p>Oracle DB/Windows XP:- 
  I am running an batch file  that calls an  “.ctl” file   which in turn calls an “.xls” file, both present in the same folder.
  The idea is to load the data onto Oracle db present on an remote oracle server.(non local machine)</p>
  
  <p>I am getting this error, no matter what I do.</p>
  
  <blockquote>
    <p>Oracle error:- LRM-00116: syntax error at 'control' following '='</p>
  </blockquote>
  
  <p>The .bat file code is as below</p>
  
  <pre><code>    rem SET SQLLOGIN=remod/P3w1d0ry@wsd
  
      pause Ready to Load the remo.Temp_data Table
  
      sqlldr userid=%SQLLOGIN% control=TempData.ctl errors=100 
  
      pause
  
  The .ctl file is as follows:-
  LOAD DATA
  INFILE "data.xls"
  replace
  into table remo.Temp_data
  FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
  TRAILING NULLCOLS
  (
  test_abbr "rtrim(:test_abbr)",
  test_pk       "rtrim(:test_pk)",
  test_sk       "rtrim(:test_sk)",
  test_dt       "rtrim(:test_dt)",
  test_email       "rtrim(:test_email)",
  )
  </code></pre>