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