On 12-Jul-2006 John Scoles wrote: > > http://svn.perl.org/modules/dbd-oracle/trunk/DBD-Oracle-1.18-RC1.zip > > =head1 Changes in DBD-Oracle 1.18 (scn rev 6642) > > Updated README.win32.txt fixed some typos updated for 10XE > Added code to inplement support for the native OCI Array Interface with > execute_array from orginal patches by Kristian Nielsen and others. > Fixed expanded support for Lobs support from Jeffrey Klein > Added notes on expanded support for Lobs to Oracle.pm > > 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
John,
Thanks for this. Here is what happened when I tried it.
BTW, that link you included was to a .zip file that seems to be a gzipped zip
file.
The machine I was testing on has Oracle XE 10.2.0 Server AND instant client
10.1. My Oracle Server is working fine and I was using DBD::Oracle 1.17 OK with
DBI 1.51 but I had built it ignoring the instant client. Here is what happens
out of the box as it were:
This is perl, v5.8.8 built for i686-linux
Building against the 10.2.0 Server
==================================
ORACLE_SID=XE
ORACLE_USERID=system/[EMAIL PROTECTED]
ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
LD_LIBRARY_PATH=
Output of perl Makefile.PL in attachement 1.
It includes a few warnings:
Unquoted string "typedef" may clash with future reserved word at (eval 179)
line 1.
Operator or semicolon missing before &typedef at (eval 179) line 1.
Ambiguous use of & resolved as operator & at (eval 179) line 1.
Scalar found where operator expected at (eval 210) line 1, near "'int' $__val"
(Missing operator before $__val?)
Constant subroutine __need_timeval undefined at
/usr/lib/perl5/5.8.8/i386-linux-thread-multi/bits/time.ph line 23.
and says:
"Using DBD::Oracle 1.17." - don't know why is says this - perhaps the version
is not rolled to 1.18 yet.
The make then contains a load of warnings - see attachment 2 but they include
stuff like
a number of these:
dbdimp.c:nnn: warning: value computed is not used
oci8.c:nnn: warning: 'xxx' defined but not used
A make test runs fine and our existing code using DBD::oracle seems to work as
far as I've run it.
Building against instant client 10.1 on same machine
====================================================
Note the sqlplus that you can download as part of instant client tools works
fine and connects to my server.
ORACLE_SID=XE
ORACLE_USERID=system/[EMAIL PROTECTED]
ORACLE_HOME=
LD_LIBRARY_PATH=
NB. I don't have ORACLE_HOME in my environment as per Oracle's instructions for
using instant client and if you set ORACLE_HOME with instant client the client
won't work.
==========
The output from perl Makefile.PL is:
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
You don't have a libclntsh.so file, only
/home/martin/instantclient10_1/libclntsh.so.10.1
So I'm going to create a /home/martin/instantclient10_1/libclntsh.so symlink to
/home/martin/instantclient10_1/libclntsh.so.10.1
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.
==========
Same results if you follow the README and do it again with perl Makefile.PL
-nob. Couldn't see anything in README.help.txt that looked like this.
I don't know why it contains those warnings about things not working if
ORACLE_HOME is set because my belief is that things don't work if ORACLE_HOME
is set. Like wise with automatically setting ORACLE_HOME.
I don't see anything in README.linux that seems to explain this.
If you want to investigate any of this further let me know - I can provide or
try anything reasonable.
Martin
--
Martin J. Evans
Easysoft Ltd, UK
http://www.easysoft.com
2
Description: Binary data
1
Description: Binary data
