Re: Problem in connecting Perl with Oracle

John Scoles <[email protected]>
Newsgroups gmane.comp.lang.perl.modules.dbi.sybase.devel
Organization The Pythian Group
Message-ID <[email protected]>
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
>
>
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.