title: Oracle unable to convert from LONG datatype to CLOB datatype( incosistent datatype error)
body: <p>Oracle 11g is giving me the following error while trying to convert a long datatype to a clob.
  I try: <code>select to_lob(long_col_name) from table1.</code>
  I get :</p>
  
  <pre><code>[Error] Execution (1: 39): ORA-00932: inconsistent datatypes: expected - got LONG
  </code></pre>
  
  <p>What am i doing wrong here?</p>