From: KUBO Takehiro <kubo@...>
Date: 2008-02-21T18:12:43+09:00
Subject: Re: Confused about OCI8

Hi,

On Thu, Feb 21, 2008 at 1:20 AM,  <eddy.pagotto@gmail.com> wrote:
>  With Ruby (version 1.8.6/Win32) I installed the OCI8, then I copied
>  the necessary DLL libraries
>  from a Oracle/bin directory (such as OCI.DLL) because I don't have the
>  Oracle client on my machine,
>  and the Instant client I can download from Oracle's site is the 11g
>  version which doesn't support Oracle 8.

Full client's OCI.DLL won't work if it is copied to outside the installed
directory. You need to install the Oracle client on your machine.
It may work by copying all files under ORACLE_HOME and all
registry keys under \\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE.
But I'm not sure that is all.

>  So, finally I tried some code.
>  First an example from the Oracle's site:
>
>   ruby -r oci8 -e "OCI8.new('user', 'pwd10', '//10.0.0.22:1521/
>  TEST').exec('SELECT * FROM test_table
>   WHERE rownum = 1') do |r| puts r.join(' | '); end"

'//10.0.0.22:1521/TEST' is a new feature of Oracle 10g.
It won't work on older Oracle versions.