The procedure entry point slcvs2ptr could not be located in the dynami

[dhawal]

When I try to run my script that tries to connect to an Oracle8 database I get the following message in a pop-up window from Perl.exe:

The procedure entry point slcvs2ptr could not be located in the dynamic link library oracore9.dll

I have Oracle9i and Oracle8i client software installed on my machine and I am able to connect to ACD1 using SQL*Plus from either version. OS is Windows XP.

--------------------------------------------------------
script to test connecting to Oracle database:
--------------------------------------------------------
use strict;
use DBI;

my $dbh = DBI->connect( 'dbi:Oracle:acd1',
'intcustapp',
'password',
{
RaiseError => 1,
AutoCommit => 0
}
) || die "Database connection not made: $DBI::errstr";

my $sql = qq{ SELECT sysdate, user FROM dual };
my $sth = $dbh->prepare( $sql );
$sth->execute();

my( $today_dt, $user_name );
$sth->bind_columns( undef, \$today_dt, \$user_name );

while( $sth->fetch() ) {
print "$today_dt, $user_name\n";
}

$sth->finish();
$dbh->disconnect();

 

[PaulTEG]

This is a problem with your oracle installation more than likely.

I saw a similar thread unresolved and contacted the thread creator on a different forum, and he said that his path environment variable was pointing to oracle 9 directory

HTH
Paul

 

[PaulTEG]

Tell him to get in touch with me, if that can help.

Above all tell him to search for how many oracore9.dll
he has on his computer (in the various ORAHOME/bin
directories) and to make sure that the PATH env
variable points on the oracore9.dll that comes from
the database install.

Rgds,

~~~~~~~

Dhawal, this is the mail he sent me, Hope it helps
Paul

 

[dhawal]

Paul

Thank you very much for your help. It helped resolve the problem. Here is what I did.

1) Checked PATH variable.

It had refrence to Oracle Internet Development Suite's bin dir before Oracle9's bin directory. Both these have the dll file.

2) At the cmd prompt, I changed the path:

set path=c:\oracle\ora92\bin;%PATH%

3) Then ran perl script

perl testdbi.pl

PS: Both the dll's were from Oracle - one got installed with Oracle9i client install and the other got installed with Oracle9ids install.

Thanks for your hekp once again.

Dhawal