//Открытие BLOB
            BLOB[] b =  new  BLOB[ 1 ];
            OracleConnection conn = (OracleConnection)getConnection();
            OracleStatement statement = (OracleStatement)conn.createStatement();
            OracleResultSet result = 
                (OracleResultSet)statement.executeQuery("select APPLICATION from request where ID=7");
             while  (result.next()) {
                b[ 0 ] = result.getBLOB( 1 );
            }
            result.close();
            statement.close();
 //Чтение из BLOB в строку
            String applicationAsString = "";
            InputStream in = b[ 0 ].getBinaryStream();
             int  r;
             char  c;
             while  ((r = in.read()) != - 1 ) {                
                c = ( char )r;
                 applicationAsString = applicationAsString + c;
            }
            in.close();