When i run the above code i.e.
require 'oci8'

begin
  conn = OCI8.new("system","manager","db")
  conn.exec('select host_name, instance_name from v$instance') do |r|
    puts r
  end
  conn.logoff
end


After having Prerequisites:

Prerequisites:
- have clean ruby 1.8.6 installation
- have running oracle client
- ruby-oci8-1.0.6-mswin32.rb

It gives me following error:


C:\testwatir>ruby contest.rb
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
        from 
c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `ge
m_original_require'
        from 
c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `re
quire'
        from contest.rb:1


Please help me.
-- 
Posted via http://www.ruby-forum.com/.