dbTalk Databases Forums  

Problem using Perl DBI-DBD against Oracle

comp.databases.oracle.server comp.databases.oracle.server


Discuss Problem using Perl DBI-DBD against Oracle in the comp.databases.oracle.server forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
GBA-DBA
 
Posts: n/a

Default Problem using Perl DBI-DBD against Oracle - 04-04-2006 , 09:57 AM






Hi, I'm trying to run this Perl script against a remote Oracle 10g R1
database. I'm using WinXP and i already have the oracle client software
installed and working.

My Perl version is 5.8.7
DBI version is: 1.50
DBD version is: 1.17

#!perl -w

use strict;

use DBI;

my $dbh = DBI->connect( 'dbi:Oracle:maxdev1', 'scott', 'tiger',

{ RaiseError => 1, AutoCommit => 0 } );

print $dbh->selectrow_array(qq{ SELECT 'Hello World' FROM DUAL });

$dbh->disconnect( );

This is the error message i get:

install_driver(Oracle) failed: Can't load
'C:/Perl/site/lib/auto/DBD/Oracle/Oracle.dll' for module DBD::Oracle:
load_file:The specified procedure could not be found at
C:/Perl/lib/DynaLoader.pm line 230.
at (eval 3) line 3
Compilation failed in require at (eval 3) line 3.
Perhaps a required shared library or dll isn't installed where expected
at C:\Perl\code\select_dual_short.plx line 9

Any clues about what can be wrong??

Regards
GBA


Reply With Quote
  #2  
Old   
Anurag Varma
 
Posts: n/a

Default Re: Problem using Perl DBI-DBD against Oracle - 04-04-2006 , 10:16 AM







Maybe a bad DBD/DBI installation ...
Try rebuilding/reinstalling DBD.

Anurag


Reply With Quote
  #3  
Old   
GBA-DBA
 
Posts: n/a

Default Re: Problem using Perl DBI-DBD against Oracle - 04-04-2006 , 10:42 AM



I already tried three times without luck. By the way, it doesn't throw
any error message when i do the install.

Regards
GBA


Reply With Quote
  #4  
Old   
Anurag Varma
 
Posts: n/a

Default Re: Problem using Perl DBI-DBD against Oracle - 04-04-2006 , 11:10 AM




hmm .. not sure then.
You might want to post your question in the dbi newsgroup also.
Also check out:

http://dbi.perl.org/support/

Anurag


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.