Re: Oracle-OCI-0.02 - Oracle 8.0.5

[email protected] (Tim Bunce) Wed, 6 Jun 2001 20:23:39 +0100
Newsgroups perl.dbi.oracle-oci
Organization Paul Ingram Group, Software Systems, +44 1 483 862800
Message-ID <[email protected]>
On Wed, Jun 06, 2001 at 11:34:57AM -0500, Scott T. Hildreth wrote:
> 
> I am running Oracle 8.0.5 on FreeBSD under Linux Emulation.
> I was able to compile a new Linux Perl(5.6.1)..okay Tim, 
> no more perl5.00404 :-).  I've compiled DBD::Oracle 1.07
> with success.  When I run the boot script for Oracle-OCI-0.02
> it compiles fine, but the connect test fails :
> 
> qw(&runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t
> t/connect...........Can't load 'blib/arch/auto/Oracle/OCI/OCI.so' for module
> Oracle::OCI: blib/arch/auto/Oracle/OCI/OCI.so: undefined symbol:
> OCIStmtBindByPos at /usr/lib/perl5/5.6.1/i386-linux/DynaLoader.pm line 206.
>  at t/connect.t line 8

"If it offends you then cut it out" :)

In this case try adding "StmtBind" to the list of excluded subs
in the boot script. That way no code will be generated for it.

You may need to repeat that process a few times if the cause is that
Oracle's headers include prototypes for subs that don't exist in the
library.  Which seems to be the case here (thanks to Roy Seto for the info).

Tim.