Re: getting perl to work with oracle

On Sun, 26 Jun 2005 16:29:52 +1000, "Andrew Rich" <vk4tec_at_hotmail.com> wrote:

>from what I have read, i need to install oracle instant client on my linux
>box and set some environ variables to get perl to talk to oracle ?
>
>1) Engage Oracle.pm
>2) Download and install instant client
>3) Set oracle home etc
>
>Anybody done this ?

 Better support for Instant Client is supposed to be in the next (unreleased) version of DBD::Oracle, but the latest version can be persuaded to compile and run against it. (Running against Instant Client is easy if it's been compiled against an equivalent full client install, compiling against Instant Client in the first place is harder).

 You need the Basic instant client package to run, and the SDK package to compile. Search for "dbi-users instant client" on Google for some info.

 It is considerably easier to compile DBD::Oracle using an ordinary Oracle client installation though - this works out of the box without fiddling.

-- 
Andy Hassall / <andy@andyh.co.uk> / <http://www.andyh.co.uk>
<http://www.andyhsoftware.co.uk/space> Space: disk usage analysis tool