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 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]<watir-general%[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]
