John,
I get the same problem as Philip Garrett in the execute_array test.
Most of the problems I reported for RC1 are now gone but I've still had no luck
getting instant client to work. I'm trying to make this work but struggling
- see below.
With LD_LIBRARY_PATH including my instant client dir and ORACLE_HOME not set
(as per Oracle's instructions for instant client) I get:
$ perl Makefile.PL
Using DBI 1.51 (for perl 5.008008 on i386-linux-thread-multi) installed in
/usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/auto/DBI/
Configuring DBD::Oracle for perl 5.008008 on linux (i386-linux-thread-multi)
Remember to actually *READ* the README file! Especially if you have any
problems.
Trying to find an ORACLE_HOME
Your LD_LIBRARY_PATH env var is set to '/home/martin/instantclient10_1/'
Found /home/martin/instantclient10_1/
WARNING: Setting ORACLE_HOME env var to /home/martin/instantclient10_1/ for you.
WARNING: The tests will probably fail unless you set ORACLE_HOME yourself!
Using Oracle in /home/martin/instantclient10_1/
SP2-0642: SQL*Plus internal error state 2165, context 4294967295:0:0
Unable to proceed
If sqlplus failed due to a linker/symbol/relocation/library error
or similar problem
then it's likely that you've not configured your environment
correctly.
Specifically, your LD_LIBRARY_PATH environment variable
set to include the directory containing the Oracle libraries.
I'm having trouble finding your Oracle version number... trying harder
WARNING: I could not determine Oracle client version so I'll just
default to version 8.0.0.0. Some features of DBD::Oracle may not work.
Oracle version based logic in Makefile.PL may produce erroneous results.
You can use "perl Makefile.PL -V X.Y.Z" to specify a your client version.
Oracle version 8.0.0.0 (8.0)
Looks like an Instant Client installation, okay
Your LD_LIBRARY_PATH env var is set to '/home/martin/instantclient10_1/'
Oracle sysliblist:
invalid top directory at /usr/lib/perl5/5.8.8/File/Find.pm line 592.
NOTE: the failure with sqlplus IS down to setting ORACLE_HOME with instant
client.e.g.
export ORACLE_HOME=/home/martin/instantclient10_1
/home/martin/instantclient10_1/sqlplus
SP2-0642: SQL*Plus internal error state 2165, context 4294967295:0:0
Unable to proceed
unset ORACLE_HOME
/home/martin/instantclient10_1/sqlplus
Works :-)
If I comment out the line in Makefile.PL which sets ORACLE_HOME it gets a bit
further i.e. it finds the oracle version:
$ perl Makefile.PL
Using DBI 1.51 (for perl 5.008008 on i386-linux-thread-multi) installed in
/usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/auto/DBI/
Configuring DBD::Oracle for perl 5.008008 on linux (i386-linux-thread-multi)
Remember to actually *READ* the README file! Especially if you have any
problems.
Trying to find an ORACLE_HOME
Your LD_LIBRARY_PATH env var is set to '/home/martin/instantclient10_1/'
Found /home/martin/instantclient10_1/
WARNING: Setting ORACLE_HOME env var to /home/martin/instantclient10_1/ for you.
WARNING: The tests will probably fail unless you set ORACLE_HOME yourself!
Using Oracle in /home/martin/instantclient10_1/
DEFINE _SQLPLUS_RELEASE = "1001000400" (CHAR)
Oracle version 10.1.0.4 (10.1)
Looks like an Instant Client installation, okay
Your LD_LIBRARY_PATH env var is set to '/home/martin/instantclient10_1/'
Oracle sysliblist:
invalid top directory at /usr/lib/perl5/5.8.8/File/Find.pm line 592.
As before, any suggestions welcome - I'm still looking in to this.
Martin
--
Martin J. Evans
Easysoft Ltd, UK
http://www.easysoft.com
On 14-Jul-2006 John Scoles wrote:
>
> http://svn.perl.org/modules/dbd-oracle/trunk/DBD-Oracle-1.18-RC2.zip
>
> =head1 Changes in DBD-Oracle 1.18 (scn rev 6647)
>
> Updated README.win32.txt fixed for some more typos
> Fixed some waring messages found in
>
> Oracle.xs
> dbdimp.c
> and oci8.c
>
> and added the test
>
> t\26exe_array.t
>
> So far things look good and thanks for all the testing. Look like we can get
> this out next week sometime.
>
> Any and all testing would be greatly appreciated, but especially testing of
> building against Oracle Instant Client and Oracle XE
> on a range of platforms.
>
> Thanks!
>
> John
