ASPN ActiveState Programmer Network
ActiveState
/ Home / Perl / PHP / Python / Tcl / XSLT /
/ Safari / My ASPN /
Cookbooks | Documentation | Mailing Lists | Modules | News Feeds | Products | User Groups


Recent Messages
List Archives
About the List
List Leaders
Subscription Options

View Subscriptions
Help

View by Topic
ActiveState
.NET Framework
Open Source
Perl
PHP
Python
Tcl
Web Services
XML & XSLT

View by Category
Database
General
SOAP
System Administration
Tools
User Interfaces
Web Programming
XML Programming


MyASPN >> Mail Archive >> perl-dbi-dev
perl-dbi-dev
Re: Problem in connecting Perl with Oracle
by John Scoles other posts by this author
Jun 11 2008 6:38AM messages near this date
Problem in connecting Perl with Oracle | Perl 5.10.0
You are using an older Oracle client that does not have

OCIXML TypeCreateFromSrc

Either use an earlier version of  DBD.Oracle like 1.20 or 1.19  or 
update you Oracle client to the latest version of the instant client.

can you post what the results of your Makefile.PL and your compile where.

You might want to check that the what your Path setting is as well
Kanhaiya Prasad wrote:
>  Hello
> 
>  I've installed Perl 5.10 successfully and all other perl program running
>  perfectly.
>  But it's showing following problem when i'm trying to connect oracle
>  Problem:
>  1. The procedure entry point OCIXML TypeCreateFromSrc could not be located
>  in the dynamic link library OCI.dll.
>  2. install_driver(Oracle) failed: Can't load
>  'C:/Perl/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
>  202
>  at (eval 4) line 3
>  Compilation failed in require at (level 4) line 3.
>  Perhaps a required shared library or dll isn't installed where expected at
>  dbi.pl line 3
>  See below mentioned coding from which I intended to connect Oracle (dbi.pl)
>  use strict;
>  use DBI;
>  my $dbh = DBI->connect( 'dbi:Oracle:orcl','scott','tiger',)|| die "Database
>  connection not made: $DBI::errstr";
>  $dbh->disconnect();
>  Thanks
>  Kanhaiya Prasad
>  Delhi
> 
>    
Thread:
Kanhaiya Prasad
John Scoles

Privacy Policy | Email Opt-out | Feedback | Syndication
© 2004 ActiveState, a division of Sophos All rights reserved