I encountered this same problem a few days ago, and the solution was to
reset the Oracle environment variables and the LD_LIBRARY_PATH var.
I have also run into some segmentation faults from the disconnect() method
when connecting to 8.1.7. Haven't tracked that down yet, though.
Good luck...
Chris
-----Original Message-----
From: Michael Klein [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 20, 2001 1:04 PM
To: [EMAIL PROTECTED]
Subject: PERL DBI with Oracle 8.1.7?
Has anyone encountered any problems running the PERL DBI with Oracle
8.1.7?
I didn't have any problems with Oracle 8.1.5, but after an upgrade to
Oracle 8.1.7, I'm now getting the error message shown at the bottom of
this message. I checked and found that the Oracle.so file does exist.
I then looked at DynaLoader.pm on line 200 and found the following
comment:
# Many dynamic extension loading problems will appear to come from
# this section of code: XYZ failed at line 123 of DynaLoader.pm.
# Often these errors are actually occurring in the initialisation
# C code of the extension XS file. Perl reports the error as being
# in this perl code simply because this was the last perl code
# it executed.
my $libref = dl_load_file($file, $module->dl_load_flags) or
croak("Can't load '$file' for module $module: ".dl_error());
install_driver(Oracle) failed: Can't load
'/usr/local/lib/perl5/site_perl/5.6.0/sun4-solaris/auto/DBD/Oracle/Oracle.so
'
for module DBD::Oracle: ld.so.1: /usr/local/bin/perl: fatal:
libclntsh.so.8.0: open failed: No such file or directory at
/usr/local/lib/perl5/5.6.0/sun4-solaris/DynaLoader.pm line 200.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at ./myfile.pl line 91
Any ideas?
Thanks for your time,
Mike
