oracle adapter raise an 'select_rows is an abstract method'

I investigated that a bit, it seems that oracle_adapter.rb does not implement the select_rows method.

I looked at postgresql._adapter.rb and sqlserver_adapter.rb and both implement it.

I guess this is the problem. It is the same for insert, update, ... The svn log doesn't show anything about that.

I wonder how it was working up to the 1.2.6.

I'm running into the same issue. There's a workaround for it here:

http://www.ruby-forum.com/topic/127249#592152

Minor changes to 2.0

Found the same problem on rake db:test:clone solved with the following minor change to oracle_adapter.rb code:-

      # Returns an array of arrays containing the field values.
      # Order is the same as that returned by #columns.
        def select_rows(sql, name = nil)
          result = select(sql, name)
          result.map{ |v| v.values}
        end

Also added to personally changes like use of BINARY_DECIMAL type for true float in oracle and CHAR(1) for boolean with support for (T/F Y/N and +/-) as used in a number of systems I have worked on.

One small problem with changing :float from NUMBER to BINARY_DECIMAL is that this new IEEE floating-point type was released in 10g.

I believe that :float should be change from NUMBER to FLOAT as the default Oracle precision for floats of 126 is invalid for NUMBER. This would also allow support for pre 10g databases.