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 |