Trying to set up DBI for oracle

[Achilles_2]

Hello there,

I am trying to set up DBI Oracle stuff on HPUX 11.00 and the perl version is

perl D.5.8.8.A 5.8.8 Perl Programming Language

I have been using the following test script.

#!/opt/perl/bin/perl
use DBI;
$dbh = DBI->connect( "dbi:Oracle:gen3", "user", "pass" );

The error message after the execution:

install_driver(Oracle) failed: Can't locate DBD/Oracle.pm in @INC (@INC contains: /opt/perl_32/lib/5.8.8/PA-RISC1.1-thread-multi /opt/perl_32/lib/5.8.8 /opt/perl_32/lib/site_perl/5.8.8/PA-RISC1.1-thread-multi /opt/perl_32/lib/site_perl/5.8.8 /opt/perl_32/lib/site_perl /opt/perl_32/lib/vendor_perl/5.8.8/PA-RISC1.1-thread-multi /opt/perl_32/lib/vendor_perl/5.8.8 /opt/perl_32/lib/vendor_perl .) at (eval 4) line 3.
Perhaps the DBD::Oracle perl module hasn't been fully installed,
or perhaps the capitalisation of 'Oracle' isn't right.
Available drivers: DBM, ExampleP, File, Proxy, Sponge.
at ./db.pl line 27

Anyone know what the modules I need and how to add them.

[Oviwan]

Hey

Check whether you have installed the DBI and DBD module:
$perldoc perllocal

if there is no entry in this output install it:

$perl -MCPAN -e 'install DBI'
$perl -MCPAN -e 'install DBD::Oracle'

or manually from here:
http://search.cpan.org/

Regards

[Rob Leadbeater]

Hi,

That error message looks clear enough to me. You've installed DBI, but you haven't installed DBD::Oracle (or not installed it correctly).

I'm not sure if there are bundled HP-UX versions, however if you start at http://dbi.perl.org you should be able to get the information you need...

Hope this helps,

Regards,

Rob