public   static   void  xmltype_search(Connection con)
    {
    Statement st= null ;
    ResultSet rs= null ;
    OracleResultSet ors= null ;
    String cmd= null ;
    Reader reader= null ;
    CLOB clob= null ;
     int  num;
     char [] cbuf= new   char [CLOB.MAX_CHUNK_SIZE];
     int  i;
         try 
        {
        Writer xmlwriter= new  OutputStreamWriter( new  FileOutputStream("e:/files/xmlhere.xml"));
        st=con.createStatement();
        rs=st.executeQuery("SELECT e.cdata.getClobVal()\n" +
                "FROM xmltype e where e.cdata.extract('/metadataFileIdentifier[xmlns=\"http://www.who.com\"]/text()').getStringVal()='http://cliware.meteo.ru/egfd_catalog/metadata/oa_goms_Planeta.xml'");
         //rs=st.executeQuery("select t.cdata.getClobval() from xmltype t");
        System.out.println("Update: "+rs);
        ors=(OracleResultSet)rs;
        System.out.println("The search resulted in:");
         while  (rs.next())
            {clob=ors.getCLOB( 2 );
             reader=clob.getCharacterStream();
              while  ((i=reader.read(cbuf))!=- 1 )
             {
             cmd=ors.getString( 2 );
             System.out.println(cmd);
             xmlwriter.write(cbuf);
             }
             xmlwriter.close();
            }
            }
         catch  (SQLException e)
        {System.out.println(e.getMessage());}
         catch  (IOException e){System.out.println(e.getMessage());}
    }