# Connecting to Oracle error

**URL:** <https://www.ruby-forum.com/t/connecting-to-oracle-error/85761>\
**Category:** Ruby\
**Created:** [February 16, 2007, 3:34am UTC](https://www.ruby-forum.com/t/connecting-to-oracle-error/85761 "2007-02-16T03:34:50Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![EZEZEZ](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/e/9de053/32.png) [@EZEZEZ](https://www.ruby-forum.com/u/EZEZEZ)\
**Post date:** [February 16, 2007, 3:34am UTC](https://www.ruby-forum.com/t/connecting-to-oracle-error/85761/1 "2007-02-16T03:34:50Z")

</div>

Hi,

I just downloaded Ruby and Watir as well and my local XE Oracle database  
and trying a basic connection to Oracle database and I am getting this  
error: “custom\_require.rb:27:in `gem\_original\_require’: no such file to  
load – oci8 (LoadError).”

Here is my code:

require ‘oci8’

connection = OCI8.new(‘ops$etfiop’, ‘etfiop’, ‘XE’)  
connection.exec(“select \* from dual”) do |row|  
puts 'dummy: ’ + row[0] # outputs “dummy: X”  
end  
connection.logoff

Any ideas???

Thanks,  
EZ

---

<div class="post-metadata">

**Author:** ![EZEZEZ](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/e/9de053/32.png) [@EZEZEZ](https://www.ruby-forum.com/u/EZEZEZ)\
**Post date:** [February 16, 2007, 7:49am UTC](https://www.ruby-forum.com/t/connecting-to-oracle-error/85761/2 "2007-02-16T07:49:27Z")

</div>

EZ wrote:

> Hi,
> 
> I just downloaded Ruby and Watir as well and my local XE Oracle database  
> and trying a basic connection to Oracle database and I am getting this  
> error: “custom\_require.rb:27:in `gem\_original\_require’: no such file to  
> load – oci8 (LoadError).”
> 
> Here is my code:
> 
> require ‘oci8’
> 
> connection = OCI8.new(‘ops$etfiop’, ‘etfiop’, ‘XE’)  
> connection.exec(“select \* from dual”) do |row|  
> puts 'dummy: ’ + row[0] # outputs “dummy: X”  
> end  
> connection.logoff
> 
> Any ideas???
> 
> Thanks,  
> EZ

Hi EZ,  
It seems that you don’t have oci8 library installed.  
In order to do that, go to: [http://ruby-oci8.rubyforge.org/en/](http://ruby-oci8.rubyforge.org/en/) and  
follow the steps that are described there.

Best regards,  
Alin

Seems that you don’t have oci8 library installed.  
In order to