Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > Ruby > Connecting to Oracle error

Reply
Thread Tools

Connecting to Oracle error

 
 
EZ
Guest
Posts: n/a
 
      02-16-2007
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

--
Posted via http://www.ruby-forum.com/.

 
Reply With Quote
 
 
 
 
Alin Popa
Guest
Posts: n/a
 
      02-16-2007
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/ and
follow the steps that are described there.

Best regards,
Alin

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

--
Posted via http://www.ruby-forum.com/.

 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Error connecting to Oracle Robin9876 ASP .Net 6 02-21-2008 12:13 PM
error rising while connecting oracle 9i python_eager Python 2 01-07-2006 12:29 AM
install_driver(Oracle) failed: Can't load 'C:/Perl/site/lib/auto/DBD/Oracle/Oracle.dll' for module DBD::Oracle: load_file:The specified procedure could not be found at C:/Perl/lib/DynaLoader.pm line 230. Feyruz Perl Misc 4 10-14-2005 06:47 PM
Re: Error Connecting to Oracle after an Oracle shutdown David Rudder Java 0 07-30-2003 01:22 PM
Re: Error Connecting to Oracle after an Oracle shutdown Juha Laiho Java 0 07-30-2003 10:22 AM



Advertisments