title: How to query a CLOB column in Oracle
body: <p>I'm trying to run a query that has a few columns that are a CLOB datatype. If i run the query like normal, all of those fields just have <code>(CLOB)</code> as the value.</p>
  
  <p>I tried using <code>DBMS_LOB.substr(column</code>) and i get the error </p>
  
  <pre><code>ORA-06502: PL/SQL: numeric or value error: character string buffer too small
  </code></pre>
  
  <p>How can i query the CLOB column?</p>