UNIX 下安装PERL 并支持ORACLE 数据库

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;
~