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

This probably a dumb question but I'm kinda new to Perl.

I've installed the Oracle DB kit but am getting the above error when I try "use DBI;" + "use DBD::Oracle;"

The full error is :

Can't locate DBD/Oracle.pm in @INC (@INC contains: /usr/local/lib/perl5/5.6.0/alpha-dec_osf /usr/local/lib/perl5/5.6.0 /usr/local/lib/perl5/site_perl/5.6.0/alpha-dec_osf /usr/local/lib/perl5/site_perl/5.6.0 /usr/local/lib/perl5/site_perl .)

Oracle.pm however does exist in one of the above paths...see below :

spatial01:osw_adm$ pwd /usr/local/lib/perl5/site_perl/5.005/alpha-dec_osf

spatial01:osw_adm$ ls DBD
ADO.pm ExampleP.pm NullP.pm Oracle.pm Proxy.pm Sponge.pm

Do I have to specify the path somewhere else? Why is perl not finding Oracle.pl?

Any help would be much appreciated.

Thanks.

Replies are listed 'Best First'.
Re (tilly) 1: Can't locate DBD/Oracle.pm in @INC
by tilly (Archbishop) on Jan 09, 2001 at 17:03 UTC
    You have perl 5.6 installed. DBD::Oracle is installed in a 5.005 path. If you run your script with 5.005 (which is probably something like /usr/local/bin/perl5.005_03) it should work.

    Or get a sysadmin to install DBD::Oracle for 5.6.

    (I would recommend the former. 5.6.0 has a few bugs that I don't like. 5.6.1 is nearly out.)

[reply]
Re: Can't locate DBD/Oracle.pm in @INC
by agoth (Chaplain) on Jan 09, 2001 at 16:54 UTC
    You shouldnt need to specify >use DBD::Oracle, the use of the Oracle driver is specified in the DBI->connect string and DBI will load it for you,
    HTH.
[reply]
Re: Can't locate DBD/Oracle.pm in @INC
by Philip (Initiate) on Jan 09, 2001 at 17:13 UTC
    Doh, Doh, Doh, Doh!!!!! Took path from wrong box!!

    It is installed in 5.6.0

    zebedee:osw_adm:t:$ pwd
    /usr/local/lib/perl5/site_perl/5.6.0/alpha-dec_osf

    zebedee:osw_adm:t:$ ls DBD
    ADO.pm ExampleP.pm Multiplex.pm NullP.pm Oracle.pm Proxy.pm Sponge.pm
    zebedee:osw_adm:t:$
[reply]
      i have installed Indigo Perl for Windows on my XP system. When i try to make a connection with Oracle it gives me the same error. I have tried to locate the ORACLE.pm file but unable to find it. Please help me as i have waisted a lot of time on this issue. Regards, Agha Jawad
[reply]
        my email is agha.jawad@ufonegsm.net.
[reply]

Back to Seekers of Perl Wisdom