首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 开发语言 > perl python >

perl 联接远程oracle报错

2012-07-29 
perl 连接远程oracle报错Activeperl 是5.14版本,远程的oracle 是11g,在PPM看到安装了DBD-Oracle:1.30pl的

perl 连接远程oracle报错
Activeperl 是5.14版本,远程的oracle 是11g,在PPM看到安装了DBD-Oracle:1.30
pl的代码如下:

Perl code
#!/usr/bin/perl -wuse DBI;my $dbSid = "mydb";my $dbHost = "196.168.1.15:1521";my $dbUser = "admin";my $dbPassword = "admin111";my $dbh = DBI->connect("DBI:Oracle:host=$dbHost:$dbSid", $dbUser, $dbPassword) or print ($DBI::errstr);my $sth = $dbh->prepare("select sysdate from dual");$sth->execute;my @recs = "";while ( my @recs=$sth->fetchrow_array) {print $recs[0]."\n";}$dbh->finish;$dbh->disconnect;exit if(1);


错误的代码如下:
Perl code
perl.exe-无法找到入口无法定位程序输入点OCIDBStartup于动态链接库OCI.dll上.


Perl code
D:\>perl oracle.plinstall_driver(Oracle) failed: Can't load 'C:/Perl/lib/auto/DBD/Oracle/Oracle.dll' for module DBD::Oracle: load_file:找不到指定的程序。 at C:/Perl/lib/DynaLoader.pm line 191. at (eval 5) line 3Compilation failed in require at (eval 5) line 3.Perhaps a required shared library or dll isn't installed where expected at oracle.pl line 9




[解决办法]
检查ORACLE_HOME环境变量设置是否正确~

热点排行