How to connect ORACLE using PERL

Shell Programming and Scripting
1

Hi Friends,

I am having Perl 5 and Oracle 9i. I just wanna to connect Oracle DB & to perform some select query statement.

Could anyone pls let me know.

I've tried below command which i found in some website, But it throws some error.:confused:

Executed:
perl -e 'use DBI; print $DBI::VERSION,"\n";'

Output
Can't locate DBI.pm in @INC (@INC contains: /usr/perl5/5.6.1/lib/sun4-solaris-64int /usr/perl5/5.6.1/lib /usr/perl5/site_perl/5.6.1/sun4-solaris-64int /usr/perl5/site_perl/5.6.1 /usr/perl5/site_perl /usr/perl5/vendor_perl/5.6.1/sun4-solaris-64int /usr/perl5/vendor_perl/5.6.1 /usr/perl5/vendor_perl .) at -e line 1.
BEGIN failed--compilation aborted at -e line 1.

and I am not familiar with Perl. When i search for help on Google, I've found some reply like, DBI should be installed. Is this so. or are there any other way instead of using DBI.

Thanks in Advance, :smiley:
Vijay,

2

Well then, you should have a quick look at this Oracle FAQ: DBI DBD::Oracle and OraPerl FAQ and this The CPAN Search Site - search.cpan.org
its easy as abc :smiley: