Oracle Perl connectivity

rahulras

Friends ,

I know that this is a PHP forum and not Perl .
But I could not one suitable for Perl , so posting it here , just assumming that there may be many people with the knowledge .

I am running Oracle 8.1.7 on Redhat Linux 8 , on IBM Pentium 4 PC.
What I want is, I want to run Perl programs with Oracle interface . Want to interact with Oracle database .

Please convey ,
1) What type of software/driver/modules I have to install ? DBI or DBD or what ?
2) Where from I can get that ?
3) How to install that ( I know there will be documents for this ) ?

Please help .

Regards

Ajcarr-Oracle

Hi,

One of the best references I have found for Oracle & Perl is the book <b>Perl for Oracle DBAs</b>, By Andy Duncan, Jared Still [see http://www.oreilly.com/catalog/oracleperl/]. It covers how to set up the Perl - Oracle environment, links to lot's of "free" stuff and tools and utilities for DBA's.

I hope this helps ...

Thanks ~ Andrew

259415

I believe you'll need both the DBI and DBD modules. You'll need the DBD (DB Driver) and the DBI (DB Interface) I would check them out at CPAN.org/modules.

You can read through the modules.

Also, if you are looking for perl BBs, the best place for that is general sites, like google groups. If you look around you'll find a vast wealth of knowledge from perl coders on interacting with databases in general. In fact, I heard from a friend that Apache now can directly interact with Oracle with pl/sql or sql with an Apache Module.

Good Luck.

TS

3047

I heard from a friend that Apache now can directly
interact with Oracle with pl/sql or sql with an Apache
Module.

This may be the mod_plsql that Oracle ship with the
HTTP Server for iAS (the Application Server).

A search for "mod_plsql" on OTN pulls up a lot of
references.

-- CJ