title: how to Retrive the CLOB value from Oracle using java
body: <pre><code>SELECT DESCRIPTION,DETAILED_DESCRIPTION,PRIORITY,RISK_LEVE FROM Table_Name
  </code></pre>
  
  <p>The <code>DETAILED_DESCRIPTION</code> column is having value in <code>CLOB</code></p>
  
  <p>Below is the code is used to fetch the data: But i am getting the error "Error: Read error" while reading the field "DETAILED_DESCRIPTION"</p>
  
  <pre><code>Statement statement;
  
  ResultSet resultSet;
  
  oracleCon.setAutoCommit(false);
  
  statement = oracleCon.createStatement();
  
  String chdet[] = new String[8];
  String query="SELECT DESCRIPTION,DETAILED_DESCRIPTION,PRIORITY,RISK_LEVEL FROM Table_Name"; 
  
                      resultSet = statement.executeQuery(query);
                      ArrayList&lt;String&gt; record=new ArrayList&lt;String&gt;();               
  
                      while (resultSet.next())
                      {
                      record.add(resultSet.getString("DESCRIPTION"));                 
                      record.add(resultSet.getString("DETAILED_DESCRIPTION"));
                      record.add(resultSet.getString("PRIORITY"));
                      record.add(resultSet.getString("RISK_LEVEL"));              
                      }                   
                      if(record.size()&gt;0)             
                      {
                          chdet[0] = record.get(0);
                          chdet[1] = record.get(1);
                          chdet[2] = record.get(2);
                          chdet[3] = record.get(3);
                          break;                          
                      }                               
                  }
              return chdet;   
  </code></pre>