On 04/05/07, Ulf Hellströí <uhellstr / mac.com> wrote:
> Hi,
>
> I'm new on this mailing list. My name is Ulf , lives in Sweden and
> been developing for Oracle for many, many years. Used to work for
> Oracle for 10 years.
> I've been studying and learning  Ruby for aroune 2 months now and has
> done some work with Ruby and Oracle.
> As suggested i would defenly say go for Ruby/OCI8
>
> There are some good introductions on how to use Ruby with Oracle on
> OTN (Oracle Technology Network)
>
> See the following links:
>
> http://www.oracle.com/technology/pub/articles/marx-ruby.html
> http://www.oracle.com/technology/pub/articles/tate-activeerecord.html
> http://www.oracle.com/technology/pub/articles/haefel-oracle-ruby.html
> http://www.oracle.com/technology/pub/articles/saternos-rails.html

Thanks for this.  Have been trying Ruby/OCI8 and it seems to work.
Only thing is when it fetches row it is referenced as an array
(row[0], row[1]...).  Is there a way of referencing the column names
(row["username"]...).

Ben

> Kindly Rgds
> /Ulf
> Ruby/OCI8
>
> On 4 maj 2007, at 20.38, Brian Candler wrote:
>
> > On Sat, May 05, 2007 at 12:27:13AM +0900, Ben Edwards wrote:
> >> Have had a look on rubyforge and done a little looking around but not
> >> totaly sure which ruby oracle library's I should use.
> >>
> >> I am connecting to a 10g database.
> >>
> >> Ruby9i and Ruby/OCI8 seem to be the contenders, or is there
> >> something else.
> >>
> >> What would people recommend?
> >
> > ruby-oci8. It's been around for a long time, and it works well.
> > It's the API
> > used by ActiveRecord's Oracle adaptor, and it also comes with a DBD
> > for use
> > with ruby-dbi. I'm using it with Oracle 10g now.
> >
> > I've never seen or used Ruby9i though.
> >
>
>
>


-- 
Ben Edwards - Bristol, UK
If you have a problem emailing me use
http://www.gurtlush.org.uk/profiles.php?uid=4
(email address this email is sent from may be defunct)