title: Problem while using Load when clause?
body: <p>I need to reject the rows from an external table which starts (first column of every row) with some special characters (eg. <code>~</code> <code>\</code> etc) in a CSV file.</p>
  
  <p>For that I have used <code>LOAD WHEN</code> clause in the <code>ACCESS PARAMETERS</code> clause. I have been using the following statement in the Access parameters clause:</p>
  
  <pre><code>load when (1:1) != '~'
  </code></pre>
  
  <p>But it throws an error stating "INVALID CHARACTER"</p>
  
  <p>If I try to use the below statement,</p>
  
  <pre><code>load when (empname != '~empname')
  </code></pre>
  
  <p>It throws:</p>
  
  <pre><code>ERROR at line 1:
  ORA-29913: error in executing ODCIEXTTABLEFETCH callout
  ORA-06512: at "SYSTEM.EMP_PROCEDURE", line 101
  ORA-06512: at line 1
  </code></pre>
  
  <p>Line 101 in the procedure is <code>select * from emp;</code></p>
  
  <p>How do I use <code>LOAD WHEN</code> clause - any examples?</p>