String value = "Привет";
        CLOB newClob = oracle.sql.CLOB.createTemporary(connect,
                              false, oracle.sql.CLOB.DURATION_SESSION);
        newClob.open(CLOB.MODE_READWRITE);
        Writer tempClobWriter = newClob.getCharacterOutputStream();
         try  {
              tempClobWriter.write( (String) value);
              tempClobWriter.flush();
              tempClobWriter.close();
        }  catch  (IOException e) {
              e.printStackTrace();
        }
        newClob.close();
        preparedState.setClob(par,newClob);

      Statement stmt = connect.createStatement();
      ResultSet rs = stmt.executeQuery("select id,my_clob from iap.tbl_clob ");
       while  (rs.next()) {
           long  id = rs.getLong( 1 );
          System.out.print("ID = " + id + "  ");
          CLOB clob = (CLOB) rs.getClob( 2 );
           char  buffer[] =  new   char [( int ) clob.length()];
          clob.getCharacterStream( 1 ).read(buffer, 0 ,( int ) clob.length());
          String strClob =   new  String(chunk);
          System.out.println(strClob);
      }

     private   Connection localConnection()  throws  SQLException {
        DriverManager.registerDriver( new  oracle.jdbc.driver.OracleDriver());

        //String url = "jdbc:oracle:oci8:@DEV_SERVER";
        String url = "jdbc:oracle:thin:@server:1521:DEV";
        Connection conn = DriverManager.getConnection(url,"i", "mypwd");
         return  conn;
    }


     private   void  test_read() {
         try  {
            Connection connect = localConnection();
            Statement stmt = connect.createStatement();
            ResultSet rs = stmt.executeQuery("select id,my_clob from iap.tbl_clob ");
             while  (rs.next()) {
                 long  id = rs.getLong( 1 );
                System.out.print("ID = " + id + "  ");
                CLOB clob = (CLOB) rs.getClob( 2 );

                StringBuffer strBuff =  new  StringBuffer();
                 int  chunkSize =  4000 ;
                 char  chunk[] =  new   char [chunkSize];
                 int  length = ( int ) clob.length();
                 while  (strBuff.length() < length) {
                     int  readSise = (length-strBuff.length())<chunkSize ? length-strBuff.length() : chunkSize;
                    clob.getCharacterStream(strBuff.length()+ 1 ).read(chunk, 0 ,readSise);
                    strBuff.append(chunk, 0 ,readSise);
                }

                String strClob =   new  String(strBuff);
                 int  zero = strClob.indexOf("");
                 if  (zero != - 1 ) {
                    strClob = strClob.substring( 0 ,zero);
                }
                //String strClob = clob.getSubString(1, (int)clob.length());

                System.out.println(strClob);
            }

            rs.close();
            stmt.close();
            connect.close();

        }  catch  (SQLException e) {
            e.printStackTrace();  
        }  catch  (IOException e) {
            e.printStackTrace();         
        }
    }

     private   void  test_readByDBMS_LOB() {
         try  {

            DriverManager.registerDriver(
                        new  oracle.jdbc.driver.OracleDriver());
            String url = "jdbc:oracle:thin:@server:1521:DEV";
            String username = "myname";
            String pwd = "mypwd";
            Connection connect = DriverManager.getConnection(
                                url,
                                username, pwd);

            Statement stmt = connect.createStatement();
            ResultSet rs = stmt.executeQuery("select my_clob from tbl_clob t where id = 1");
             while  (rs.next()) {
                CLOB clob = (CLOB) rs.getClob( 1 );
                String buffer="";
                String chunk =  null ;
                String sqlClob =
                        "declare " +
                        " clb CLOB; " +
                        "begin " +
                        " clb := ?; " +
                        " dbms_lob.open(clb,dbms_lob.lob_readonly); " +
                        " dbms_lob.read(clb,?,?,?); " +
                        " dbms_lob.close(clb); " +
                        "end; ";
                CallableStatement cs = connect.prepareCall(sqlClob);
                 int  i =  1 ;
                 while  (chunk== null  || chunk.length()== 4000 ) {
                    cs.clearParameters();
                    cs.setClob( 1 ,clob);
                    cs.setLong( 2 , 4000 );
                    cs.setLong( 3 ,i);
                    cs.registerOutParameter( 4 ,Types.VARCHAR);
                    cs.executeUpdate();
                    chunk = cs.getString( 4 );
                    buffer = buffer + chunk;
                    i +=  4000 ;
                }
                System.out.println(buffer);
                cs.close();
            }

            rs.close();
            stmt.close();
            connect.close();

        }  catch  (SQLException e) {
            e.printStackTrace();
        }
    }