title: How to retrive clob data from oracle collection
body: <p>I have a requirment where oracle procedure is sending me a  oracle collection. This collection contains clob data type.<br>
  How do I get this clob data ?  </p>
  
  <p>Code:</p>
  
  <pre><code>    public static void main(String[] args) throws SQLException {
              DBLayer db=new DBLayer();
              CallableStatement ftRPCaStmt = null;
              ResultSet requestPropCursor = null;
              CallableStatement callsmt=null;
              String dataCol="stg_core.tab_inft_flexi_gl_rec_hd2";
              Connection conn=db.getConnection();
      ArrayDescriptor structDescriptor1 = ArrayDescriptor.createDescriptor   (dataCol.toUpperCase(), conn);                   
                    ftRPCaStmt = conn.prepareCall("{ call stg_core.gl_test1_clob_c2(?,?,?) }");
              ftRPCaStmt.registerOutParameter(1, Types.VARCHAR);
              ftRPCaStmt.registerOutParameter(2, Types.VARCHAR);
              ftRPCaStmt.registerOutParameter(3, Types.ARRAY,dataCol.toUpperCase());
              ftRPCaStmt.execute();
  
              Object[] data = (Object[]) ((Array) ftRPCaStmt.getObject(3)).getArray();    
  </code></pre>
  
  <p>when I printed data I'm getting data value as <code>Ljava.lang.Object;@b2fd8f</code>, but I need the clob data..<br>
  Please suggest..</p>