From: Michael Neumann <mneumann@...>
Date: 2004-05-08T01:59:29+09:00
Subject: Re: DBI, OCI8 and the 'tables' method

On Sat, May 08, 2004 at 01:33:55AM +0900, Daniel Berger wrote:
> Hi all,
> 
> Ruby 1.8.1
> Windows XP Pro/Solaris 9
> Oracle 9.2.x
> OCI8 0.1.7
> DBI 0.0.22
> 
> The tables() method is returning an empty array when I use DBI and the
> OCI8 driver.

I've had a quick look into OCI8 0.1.7. There's no table method defined,
and the fall-back behaviour is to return [].

This is how DBD::Oracle implements the tables method:

  def tables
    stmt = execute("SELECT table_name FROM user_tables")
    rows = stmt.fetch_all || []
    stmt.finish
    rows.collect {|row| row[0]}
  end

Try to add this piece of code to class Database in OCI8.rb, and if it
works, please send the patch to the maintainer of OCI8.

Regards,

  Michael