title: How to convert CLOB to CHAR datatype in Oracle?
body: <p>For ETL Purpose, I need to convert DB records into flat-files. For that, I have to convert all the records as CHAR. In that table, it's having few columns with CLOB datatype. So, I tried the following functions: </p>
  
  <pre><code>DBMS.LOBS_SUBSTR(column_name, Length(column_name))
  </code></pre>
  
  <blockquote>
    <p>Error: ORA-06502 Pl/sql: numeric value error: character string buffer
    too small ORA-06512: at line 1
    06502. 00000 - "PL/SQL: numeric or value error ℅s"</p>
  </blockquote>