From: Brian Candler <B.Candler@...>
Date: 2007-06-28T00:03:43+09:00
Subject: Re: how to get data from database as string

> How can i read a cell from database and retrieve as a string in ruby
> with OCI8?

There are working examples in the documentation at
http://ruby-oci8.rubyforge.org/

Click on "ruby-oci8 API" on the left-hand side, e.g. to get to
http://ruby-oci8.rubyforge.org/en/api_OCI8Cursor.html#l9

Basically you need to call fetch or fetch_hash on your cursor to get the
results from the select statement.

Alternatively, if you call exec() directly on the OCI8 object, you can pass
a block. The one-liner example on the front page demonstrates this:

  OCI8.new('scott', 'tiger').exec('select * from emp') do |r| puts r.join(','); end

HTH,

Brian.