DBD::Oracle on cygwin

[Stephan Titard]

hi,
on HP-UX (and probably anything unix-like) you don't need a full oracle
client installation to compile DBD::Oracle; a couple headers and the
[email]libclntsh@(.sl|.so[/email]) are enough.

I don't want to install a working Oracle client on my PC at home; has
anybody tried to compile DBD::Oracle on cygwin using the minimum files
(as described above)
supposing one registers the needed *dll, it seems theoretically doable....
any comments?

thanks
--stepahn

[Andy Hassall]

On Wed, 12 Jul 2006 12:09:18 +0200, Stephan Titard <sgt19@tid.es> wrote:

>on HP-UX (and probably anything unix-like) you don't need a full oracle
>client installation to compile DBD::Oracle; a couple headers and the
>libclntsh@(.sl|.so) are enough.
>
>I don't want to install a working Oracle client on my PC at home; has
>anybody tried to compile DBD::Oracle on cygwin using the minimum files
>(as described above)
>supposing one registers the needed *dll, it seems theoretically doable....
>any comments?

Yep, make sure you're using the latest DBD::Oracle (1.17), I contributed a
couple of minor patches which avoid some misleading Unicode test failures on
Cygwin due to quirks with how it sets environment variables interacting with
native libraries.

Install Oracle Instant Client, Basic + SDK + SQL*Plus packages.

Set ORACLE_HOME environment variable to the _Windows_ style path to where you
unpacked instant client (e.g. c:\oracle\instantclient_10_2).

Include the _Cygwin_ style path to the Oracle directory in PATH (e.g.
/cygdrive/c/oracle/instantclient_10_2).

Then set everything else as normal (ORACLE_USERID for a login for the tests,
NLS_LANG if necessary) and it should build and test without problems.

--
Andy Hassall :: [email]andy@andyh.co.uk[/email] :: [url]http://www.andyh.co.uk[/url]
[url]http://www.andyhsoftware.co.uk/space[/url] :: disk and FTP usage analysis tool