From: Michael Neumann <mneumann@...>
Date: 2004-05-13T21:24:53+09:00
Subject: Re: DBI, OCI8 and the 'tables' method

On Thu, May 13, 2004 at 09:14:10PM +0900, KUBO Takehiro wrote:
> Hello,
> 
> Michael Neumann <mneumann@ntecs.de> writes:
> 
> > 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.
> 
> Sorry too late to reply.
> 
> I'll include your code to the next release of ruby-oci8.
> 
> But I'll change "SELECT table_name FROM user_tables" to
> "SELECT object_name FROM user_objects where object_type in ('TABLE', 'VIEW')".
> user_tables returns tables only but DBD_SPEC says: Returns an
> (({Array})) of all tables and views.

Should I do the same in DBD::Oracle (OCI7 module)? 
Does this work in Oracle 7 too?
 
Regards,

  Michael