Re: Oracle database connection

[Errto]

To further elaborate (since I did this for the first time recently), my fellow monks are correct that DBD::Oracle is the module you want. In order to install it, however, you must already have set up a full Oracle client installation, including specifically the OCI (Oracle Call Interface) drivers for your platform. You also need to set the $ORACLE_HOME environment variable before trying to even install DBD::Oracle. This tripped me up initially because I had worked with Java on Oracle before, and in Java you have a choice of using OCI or the "thin" driver, which is pure Java and requires no ORACLE_HOME. But there is no pure Perl driver for Oracle, AFAIK.

[dragonchild]

But there is no pure Perl driver for Oracle, AFAIK.

You are absolutely correct, because there are no Oracle drivers outside of C/C++ and Java. So, there aren't any pure Haskell drivers, either.

Installing DBD::Oracle is probably the hardest single module install I've ever done, with the possible exception of DBD::mysql.

[Thilosophy]

Installing DBD::Oracle is probably the hardest single module install I've ever done

It being so close to Christmas, here is my Oracle/Perl wishlist:

Things are supposed to get lot easier once Oracle releases the overdue Instant Client SDK (not sure when this will be, though). Then, you can just install a few RPMs and DBD::Oracle should be able to build out of the box, without much fiddling with the build files and parameters.

And things are also supposed to get even more easy with Perl6/Parrot where the DBD::Oracle does not even need a (C) compiler anymore to install, relying on Parrot's cool dynamic library loaders. But here we are not talking about this year's Christmas...