From: andre hartawan <total_sc@...>
Date: 2006-12-09T14:44:57+09:00
Subject: Re: try to connect Ruby to oracle

No, it is not my first time use oracle
connection,actually i have used TOAD and It's working
properlly,but it's my first time using ruby,du u have
any suggestion ?

--- Paul Lutus <nospam@nosite.zzz> wrote:

> andre hartawan wrote:
> 
> > Need an advice please,
> > 
> > I have an error while trying to connect ruby to
> > oracle.
> > u can see the error below.What should I do ?
> > 
> > E:\ruby\bin>ruby -r oci8 -e "OCI8.new('hr', 'hr',
> > '//10.10.xx.xx:1521/oradbx').
> > exec('select * from JOBS') do |r| puts
> r.join(',');
> > end"
> > E:/ruby/lib/ruby/site_ruby/1.8/oci8.rb:49:in
> `create':
> > ERROR (OCIError)
> >         from
> E:/ruby/lib/ruby/site_ruby/1.8/oci8.rb:49
> 
> 1. Have you been able to connect to Oracle using
> this method before now? In
> other words, is this your first effort to connect,
> or is this the first
> time you have had a problem connecting?
> 
> 2. Is the Oracle server running on the provided
> address and port?
> 
> 3. Is the provided SQL accepted when using another
> way to talk to Oracle?
> 
> 4. Have you considered putting your Ruby code in a
> script, which would give
> you more control over what happens and how errors
> are reported?
> 
> -- 
> Paul Lutus
> http://www.arachnoid.com
> 
> 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com