Thanks for  your quick reply, will give a try.

On May 4, 10:35 pm, Felipe Knorr Kuhn <[email protected]> wrote:
> Hello, Ivan,
>
> I used this piece of code under Windows a while ago:
>
> require 'oci8'
> require 'dbi'
>
> connection = OCI8.new( 'username', 'password', 'ip:port/scheme')
> cursor = connection.exec('select * from table')
> while r = cursor.fetch_hash
>   r.each {|key, value| puts "#{key} is #{value}" }
> end
> puts cursor.row_count
> cursor.close
> connection.logoff
>
> You will to install the Oracle Client and the following lib:
>
> ruby-oci8 (2.0.1)
>     Ruby interface for Oracle using OCI8 API
>
> Hope that helps,
>
> FK
>
>
>
> On Tue, May 4, 2010 at 11:17 AM, Ivan Chung <[email protected]> wrote:
> > Hi guys,
>
> > some quick question here, i will need to connect to oracle database
> > and execute some queries to compare the results. Is there a specif
> > watir scripts to do that or that is ruby code to handle this?
>
> > Appreciate if there is example provided.
>
> > Thanks in advance
> > Ivan
>
> > --
> > Before posting, please readhttp://watir.com/support. In short: search
> > before you ask, be nice.
>
> > You received this message because you are subscribed to
> >http://groups.google.com/group/watir-general
> > To post: [email protected]
> > To unsubscribe: 
> > [email protected]<watir-general%[email protected]>
>
> --
> Before posting, please readhttp://watir.com/support. In short: search before 
> you ask, be nice.
>
> You received this message because you are subscribed 
> tohttp://groups.google.com/group/watir-general
> To post: [email protected]
> To unsubscribe: [email protected]

-- 
Before posting, please read http://watir.com/support. In short: search before 
you ask, be nice.

You received this message because you are subscribed to 
http://groups.google.com/group/watir-general
To post: [email protected]
To unsubscribe: [email protected]

Reply via email to