ruby problem connecting to oracle using oci8

D

Dheeraj Gambhir

Hi,

My code is:

require 'dbi'



def dataVerification()
puts "Begin Conn!"
ora_connect = DBI.connect("DBI:OCI8:eek:rcl;Data
Source=mlbd;UserId=mlbread;Password=mlbread")
oracleAccountInfoValues = getDBValue(ora_connect, "select invoice_id
from bam_order.ec_invoice where order_id =139920")
ora_connect.disconnect
ora_Id = oracleAccountInfoValues[0]
puts ora_Id

end
dataVerification()


When i run this, it gives me :

C:/ruby/lib/ruby/site_ruby/1.8/dbi.rb:329:in `load_driver': Unable to
load drive
r 'OCI8' (DBI::InterfaceError)
from C:/ruby/lib/ruby/site_ruby/1.8/dbi.rb:227:in
`_get_full_driver'
from C:/ruby/lib/ruby/site_ruby/1.8/dbi.rb:213:in `connect'
from testcon.rb:8:in `dataVerification'
from testcon.rb:15

I am using:
-Ruby 1.8.6
-Oracle 9i Enterprise Management

Please let me know if any body have any idea that why this error is
coming?

Regards
D G
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,962
Messages
2,570,134
Members
46,690
Latest member
MacGyver

Latest Threads

Top