Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Problem using Perl DBI-DBD against Oracle

Problem using Perl DBI-DBD against Oracle

From: GBA-DBA <gba.oraclel_at_gmail.com>
Date: Tue, 4 Apr 2006 10:02:52 -0500
Message-ID: <003c01c657f8$d97d95f0$912eb8a5@pavilion>


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

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Apr 04 2006 - 10:02:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US