You will have to do all three
You will need
DBI
DBD::Oracle
Oracle client
and most likely some environment variables as well
First actually read the readme files
http://search.cpan.org/src/PYTHIAN/DBD-Oracle-1.21/README it has
detailed instructions on how to set up DBD::Oracle
You can use the Oracle Instant client for free and you can get it here
http://www.oracle.com/technology/tech/oci/instantclient/index.html
cheers
John Scoels
[EMAIL PROTECTED] wrote:
Thanks for the input.
I have one more question. If I install oracle.pm will that solve my
problem or do I need to install oracle client on the unix box to make
it work.
Do I need to setup any other environment variables.
Looking forward for the answers.
Thanks,
Shikha Pandit
WHS IT - Clinical Solutions
Phone: (847) 964-8709
WHS -> Walgreens Health Services
[EMAIL PROTECTED]
07/29/2008 07:53 PM
To
[EMAIL PROTECTED]
cc
[email protected], [EMAIL PROTECTED]
Subject
Re: Questions related to DBI and DBD::Oracle
You will have to install the DBD::Oracle perl module befoer you can
use it.
http://search.cpan.org/~pythian/DBD-Oracle-1.21/Oracle.pm
so far you only have DBI or th Data Base Interface you need a Data Base
Driver to make it actually connect ot a DB. This is why it is asking for
DBD::Oracle
> Hello,
>
> I am trying to connect to the oracle database through a perl script. I
> have installed DBI module on my server.
> I need to run my script on an App server and the database is on the
other
> server.
> When I am running the test script which is
> use DBI;
> $dbh = DBI->connect( 'dbi:Oracle:dwhs01',
> 'username',
> 'password',
> ) || die "Database connection not made:
> $DBI::errstr";
>
> print "Connected to Database";
>
> It gives me this error.
> install_driver(Oracle) failed: Can't locate DBD/Oracle.pm in @INC (@INC
> contains: /usr/opt/perl5/lib/5.8.2/aix-thread-multi
> /usr/opt/perl5/lib/5.8.2
> /usr/opt/perl5/lib/site_perl/5.8.2/aix-thread-multi
> /usr/opt/perl5/lib/site_perl/5.8.2 /usr/opt/perl5/lib/site_perl .) at
> (eval 3) 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, Gofer, Proxy, Sponge.
> at test.pl line 9
>
> Please advice what all do I need to setup and install.
>
> Looking forward for the reply.
> Any inputs will be appeciated.
>
>
> Thanks,
> Shikha Pandit
> WHS IT - Clinical Solutions
> Phone: (847) 964-8709
>
> WHS -> Walgreens Health Services
<http://search.cpan.org/%7Epythian/DBD-Oracle-1.21/Oracle.pm>
