ljbailey has asked for the wisdom of the Perl Monks concerning the following question:

I executed the following Perl script:

#!/usr/local/bin/perl -W use strict; use DBI; $ENV{ORACLE_HOME} = '/u01/app/oracle/product/9.2.0'; $ENV{LD_LIBRARY_PATH} = "$ENV{ORACLE_HOME}/lib"; $ENV{TNS_ADMIN} = '/var/opt/oracle'; my $dbh = DBI->connect( 'dbi:Oracle:eldorado', 'C6037', 'C6037', { RaiseError => 1, AutoCommit => 0 } ); print $dbh->selectrow_array(qq{ SELECT 'Hello World' FROM DUAL } ); $dbh->disconnect();

I receive the following errors:

helloworld.pl install_driver(Oracle) failed: Can't locate DBD/Oracle.pm in @INC (@IN +C contains: /usr/local/lib/perl5/5.8.0/sun4-solaris /usr/local/lib/pe +rl5/5.8.0 /usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris /usr/loca +l/lib/perl5/site_perl/5.8.0 /usr/local/lib/perl5/site_perl .) at (eva +l 1) line 3. Perhaps the DBD::Oracle perl module hasn't been fully installed, or perhaps the capitalisation of 'Oracle' isn't right. Available drivers: ExampleP, Proxy. at helloworld.pl line 10

Can anyone assist me in debugging the cause of the error?

Larry

Edited 2002-11-22 by Ovid

Replies are listed 'Best First'.
Re: Error Connecting to Oracle DB
by Ovid (Cardinal) on Nov 22, 2002 at 22:12 UTC

    You don't appear to have installed DBD::Oracle. Click that link, grab it from the CPAN and see if you can install it.

    DBI is merely an interface to various database drivers (DBDs). When you install DBI, you must also ensure that you have the correct DBD for the database you are using. In this case, it's DBD::Oracle.

    Cheers,
    Ovid

    New address of my CGI Course.
    Silence is Evil (feel free to copy and distribute widely - note copyright text)