From: Amos <a.goo0h@...>
Date: 2008-01-18T00:32:32+09:00
Subject: Re: ruby-oci8-1.0.0 rowid

On Jan 15, 9:46 am, Amos <a.go...@gmail.com> wrote:
> I noticed this apparently unanswered thread:
>
> http://groups.google.com/group/comp.lang.ruby/browse_frm/thread/2ae6af9717678d39/cf37b223d5f7231f

> It would seem that this is still a problem? I'm trying to port some
> old code from oracle-0.2.11 to ruby-oci8-1.0.0 and for the most part
> it is working. However, I can't seem to figure out how to access the
> rowid from oci8.


It was pointed out to me that this works for ruby-oci8-1.0.0:


  cursor = conn.parse('select rowid, t.* from dual t')
  cursor.define(1, String, 23) # fetch 1st column as a String.
  cursor.exec
  while row = cursor.fetch
    puts row[0]
  end

As for OCI8::Cursor#rowid, it is available to get rowids of inserted
rows.

  cursor = conn.parse('insert into foo values (1, 2)')
  cursor.exec
  rowid = cursor.rowid # inserted row's rowid.


Amos