title: Converting LONG to CLOB in INFORMATICA
body: <p>I am getting below error when i run the informatica mapping, which has a <code>LONG</code> column in source and target column has data type of <code>CLOB</code>. I am trying to use <code>TO_LOB</code> and <code>TO_CLOB</code>, but not helping. In source qualifier in infa mapping there is no <code>LONG</code> or <code>CLOB</code>, so I have used data type in Source qualifier as string, text, nsting and ntext for this column, but still throwing the same error. </p>
  
  <pre><code>ORA-00932: inconsistent datatypes: expected CLOB got LONG
  </code></pre>
  
  <p>Let me know if you have come across this kind of error, converting from <code>LONG</code> to <code>CLOB</code>. </p>
  
  <p>Thanks
  Kriti</p>