From: usenet2009@... (Viktor Zacek)
Date: 2009-07-21T23:25:07+09:00
Subject: Re: Ruby/Oracle connectivity

Dheeraj Gambhir <checktestingthings@gmail.com> wrote:

Haven't been using ruby with oracle for some time...
but do you have an oracle client (or oracle instant client) installed?
AFAIK when using OCI8 this is a prerequisite.



> If i run this code to check whether i am able to connect to the Oracle
> database server or not:
> 
> ruby -r oci8 -e "OCI8.new('mlbread', 'mlbread', 'MLBD').exec('select *
> from bam_order.ec_invoice where order-id>2316027') do |r| puts r.join('
> | '); end"
> 
> It gives me:
> 
> C:\ruby>ruby -r oci8 -e "OCI8.new('mlbread', 'mlbread', 
> 'MLBD').exec('select * f
> rom bam_order.ec_invoice where order-id>2316027') do |r| puts r.join(' |
> '); end
> "
> c:/ruby/lib/ruby/site_ruby/1.8/oci8.rb:52:in `init': OCI Library 
> Initialization
> Error (OCIError)
>         from c:/ruby/lib/ruby/site_ruby/1.8/oci8.rb:52
> 
> Regards
> D G