Method: Sequel::Oracle::Dataset#fetch_rows

Defined in:
lib/sequel/adapters/oracle.rb

#fetch_rows(sql, &block) ⇒ Object 



103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
 
# File 'lib/sequel/adapters/oracle.rb', line 103

def fetch_rows(sql, &block)
  execute(sql) do |cursor|
    begin
      @columns = cursor.get_col_names.map{|c| output_identifier(c)}
      while r = cursor.fetch
        row = {}
        r.each_with_index {|v, i| row[@columns[i]] = v unless @columns[i] == :raw_rnum_}
        yield row
      end
    ensure
      cursor.close
    end
  end
  self
end