import  oracle.sql.CLOB;

 import  java.io.OutputStream;
 import  java.io.OutputStreamWriter;
 import  java.sql.*;

 public   class  ClobTest {

    private   static   final  String USERNAME = "hall";

    private   static   final  String PASSWORD = "h";

    private   static   final  String SERVER = "jdbc:oracle:thin:@<host>:<port>:<SERVICE_NAME>";

    private   static   final  String RESOURCE =
     "ЙЦУКЕНГШЩЗХЪФЫВАПРОЛДЖЭЯЧСМИТЬБЮ.йцукенгшщзхъфывапролджэячсмитьбю" +
       "QWERTYUIOP{}ASDFGHJKL:\"ZXCVBNM<>?qwertyuiop[]asdfghjkl;'zxcvbnm,.";

    public   static   void  main(String args[])
      throws  Exception {

     Connection con =  null ;
     Clob clob;
     Statement st =  null ;
     PreparedStatement pst =  null ;
     ResultSet rs =  null ;
      try  {
       DriverManager.registerDriver( new  oracle.jdbc.OracleDriver());
       con = DriverManager.getConnection(SERVER, USERNAME, PASSWORD);

       clob = CLOB.createTemporary(con, true, CLOB.DURATION_SESSION);

       clob.setString( 1 , RESOURCE);

       st = con.createStatement();
        try  {
         st.execute("drop table TEST_LOB");
       }  catch  (SQLException e) {}

       st.execute("create table TEST_LOB (cdata clob)");

       pst = con.prepareStatement("insert into TEST_LOB (cdata) values (?)");
       pst.setClob( 1 , clob);
       pst.execute();

       rs = st.executeQuery("select cdata from TEST_LOB where rownum = 1");
        if  (rs.next()) {
         Clob clob2 = rs.getClob("cdata");
         String sClob2 = clob.getSubString( 1 , ( int )clob2.length());
         System.out.println(sClob2);
       }
     }  finally  {
        if  (rs !=  null ) { rs.close(); }
        if  (pst !=  null ) { pst.close(); }
        if  (st !=  null ) { st.close(); }
        if  (con !=  null ) { con.close(); }
     }
   }
}

//clob.setString(1, RESOURCE);
((CLOB)clob).putString( 1 , RESOURCE);