title: How to call ora_hash function inside control file in sql loader?
body: <p>I'm trying to call a function(ORA_HASH) inside sqlldr but I'm not able to achive the target. </p>
  
  <p>Data File</p>
  
  <pre><code>abc.txt
  AKY,90035,"G","DP",20150121,"",0,,,,,,"","E8BD4346-A174-468B-ABC2-1586B81A8267",1,17934,5099627512855,"TEST of CLOROM","",14.00,"",14.00,17934,5099627512855,"TEST of CLOROM",14.00,"ONE TO BE T ONE",344,0,"98027f93-4f1a-44b2-b609-7ffbb041a375",,,AKY8035,"Taken Test","L-20 Shiv Lok"
  AKY,8035,"D","DP",20150121,"",0,,,,,,"","E8BD4346-A174-468B-ABC2-1586B81A8267",2,17162,5099627885843,"CEN TESt","",15.00,"",250.00,17162,5099627885843,"CEN TESt",15.00,"ONE TDAILY",3659,0,"09615cc8-77c9-4781-b51f-d44ec85bbe54",,,LLY8035,"Taken Test","L-20 Shiv Lok"
  </code></pre>
  
  <p>Control file </p>
  
  <pre><code>cnt_file.ctl
      load data
      into table Table_XYZ
      fields terminated by "," optionally enclosed by '"'
      F1,F2,F3,F4,F5,F6,F7,F8,F9,F10,F11,F12,F13,F14,F15,F16,F17,F18,F19,F20,F21,F22,F23,F24,F25,F26,F27,F28,F29,F30,F31 ORA_HASH(CONCAT(F2,F5,F6,F9,F10,F12,F13,F14,F15,F16,F17,F19,F21,F22)),F32 ORA_HASH(CONCAT(f23,H24,F7,F8,F3)),F33,F34,F35
  
  sqlldr "xxxxx/yyyyy" control=cnt_file.ctl data=abc.txt
  </code></pre>
  
  <p>whenever I'm executing sqlldr from Linux box I'm getting below error</p>
  
  <pre><code>SQL*Loader-350: Syntax error at line 4.
  Expecting "," or ")", found "ORA_HASH".
  F29,F30,F31,KEY_CLMNS_HASH ORA_HASH(CONCAT( F2,F5
                         ^                    
  </code></pre>
  
  <p>Any idea</p>