UNIX 下安装PERL 并支持ORACLE 数据库
cd perl-5.6.1
rm -f config.sh Policy.sh
sh Configure -d (选择缺省安装)
make
make test
make install
cd DBI-1.13
#perl Makefile.PL
#make
#make test
#make install
#tar -xvf DBD-Oracle-1.06.tar
cd DBD-Oracle-1.06
#perl Makefile.PL
#make
#make test
#make install
测试连接
#!/usr/bin/perl
use DBI;
$dbh=DBI->connect('dbi:Oracle:host=127.0.0.1;sid=ora7','report/system','')||
die('cann\'t connect to database');
$date=$dbh->prepare("select to_char(trunc(sysdate)-1,'yyyymmdd') from dual");
$date->execute;
while (@row = $date->fetchrow_array)
{
printf("$row[0]\n");
}
$dbh->disconnect;
~