Re: Questions related to DBI and DBD::Oracle

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



scoles@xxxxxxxxxxx
07/29/2008 07:53 PM

To
Shikha.Pandit@xxxxxxxxxxxxx
cc
dbi-users@xxxxxxxx, yuan.zhang@xxxxxxxxxxxxx
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



Relevant Pages

  • RE: DBI problem
    ... I had Oracle 8 all along, I upgraded to ActiveState Perl 5.8.7 from ... DBD 1.16 and DBI 1.48. ... Did you install DBD::Oracle? ...
    (perl.dbi.users)
  • RE: oracle win2k ORA-1222 problems
    ... AS does not provide a package, but you can and should install both DBI and DBD::Oracle from ftp.esoftmatic.com. ... Oracle is listed as "failed" if I recall correctly. ... Data Source is DBI:Oracle:Space ...
    (perl.dbi.users)
  • Re: AIX 4.3.3 , Oracle 7.3.4 coredumps at startup
    ... I cannot port the database to Oracle 8 or later since the app ... > the apps that are now reserved words in Oracle 8 and later. ... Put away your installation media and forget a new install for the moment. ...
    (comp.unix.aix)
  • RE: Accessing oracle from windows 2000
    ... You need oracle net8 anyway for odbc so it is likely you will ... just be able to install the activestate DBD::Oracle and DBI. ... > documentation on DBI and I can't find the answers I'm looking for. ...
    (perl.dbi.users)
  • Re: how to activate oracle text in 10g enterprise
    ... general purpose database, or if he wanted to study otext, and was ... 'Oracle Text' option from the DBCA screen. ... If you experienced oracle warnings and errors during the install ...
    (comp.databases.oracle.server)