On Fri, 2006-10-27 at 14:45 -0400, John Scoles wrote:
> 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.
Linux 2.6.17, Perl 5.8.8, DBI 1.51, Oracle XE 10.2.0.1 works fine.
[EMAIL PROTECTED]:~/usr/src/DBD-Oracle-1.19-RC3$ uname -a
Linux lmn12448 2.6.17-10-386 #2 Fri Oct 13 18:41:40 UTC 2006 i686
GNU/Linux
[EMAIL PROTECTED]:~/usr/src/DBD-Oracle-1.19-RC3$ perl -V
Summary of my perl5 (revision 5 version 8 subversion 8) configuration:
Platform:
osname=linux, osvers=2.6.15.7, archname=i486-linux-gnu-thread-multi
uname='linux rothera 2.6.15.7 #1 smp tue jun 27 18:34:43 utc 2006
i686 gnulinux '
config_args='-Dusethreads -Duselargefiles -Dccflags=-DDEBIAN
-Dcccdlflags=-fPIC -Darchname=i486-linux-gnu -Dprefix=/usr
-Dprivlib=/usr/share/perl/5.8 -Darchlib=/usr/lib/perl/5.8
-Dvendorprefix=/usr -Dvendorlib=/usr/share/perl5
-Dvendorarch=/usr/lib/perl5 -Dsiteprefix=/usr/local
-Dsitelib=/usr/local/share/perl/5.8.8
-Dsitearch=/usr/local/lib/perl/5.8.8 -Dman1dir=/usr/share/man/man1
-Dman3dir=/usr/share/man/man3 -Dsiteman1dir=/usr/local/man/man1
-Dsiteman3dir=/usr/local/man/man3 -Dman1ext=1 -Dman3ext=3perl
-Dpager=/usr/bin/sensible-pager -Uafs -Ud_csh -Uusesfio -Uusenm
-Duseshrplib -Dlibperl=libperl.so.5.8.8 -Dd_dosuid -des'
hint=recommended, useposix=true, d_sigaction=define
usethreads=define use5005threads=undef useithreads=define
usemultiplicity=define
useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
use64bitint=undef use64bitall=undef uselongdouble=undef
usemymalloc=n, bincompat5005=undef
Compiler:
cc='cc', ccflags ='-D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS
-DDEBIAN -fno-strict-aliasing -pipe -I/usr/local/include
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64',
optimize='-O2',
cppflags='-D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBIAN
-fno-strict-aliasing -pipe -I/usr/local/include'
ccversion='', gccversion='4.1.2 20060613 (prerelease) (Ubuntu
4.1.1-2ubuntu5)', gccosandvers=''
intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12
ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t',
lseeksize=8
alignbytes=4, prototype=define
Linker and Libraries:
ld='cc', ldflags =' -L/usr/local/lib'
libpth=/usr/local/lib /lib /usr/lib
libs=-lgdbm -lgdbm_compat -ldb -ldl -lm -lpthread -lc -lcrypt
perllibs=-ldl -lm -lpthread -lc -lcrypt
libc=/lib/libc-2.4.so, so=so, useshrplib=true,
libperl=libperl.so.5.8.8
gnulibc_version='2.4'
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Wl,-E'
cccdlflags='-fPIC', lddlflags='-shared -L/usr/local/lib'
Characteristics of this binary (from libperl):
Compile-time options: MULTIPLICITY PERL_IMPLICIT_CONTEXT
PERL_MALLOC_WRAP THREADS_HAVE_PIDS USE_ITHREADS
USE_LARGE_FILES USE_PERLIO USE_REENTRANT_API
Built under linux
Compiled at Jul 7 2006 18:08:25
@INC:
/etc/perl
/usr/local/lib/perl/5.8.8
/usr/local/share/perl/5.8.8
/usr/lib/perl5
/usr/share/perl5
/usr/lib/perl/5.8
/usr/share/perl/5.8
/usr/local/lib/site_perl
/usr/local/share/perl/5.8.7
.
[EMAIL PROTECTED]:~/usr/src/DBD-Oracle-1.19-RC3$ perl Makefile.PL
Argument "6.30_01" isn't numeric in subroutine entry at Makefile.PL line
8
main::BEGIN() called
at /usr/share/perl/5.8/ExtUtils/MakeMaker.pm line 8
eval {...} called at /usr/share/perl/5.8/ExtUtils/MakeMaker.pm
line 8
Using DBI 1.51 (for perl 5.008008 on i486-linux-gnu-thread-multi)
installed in /usr/lib/perl5/auto/DBI/
Argument "6.30_01" isn't numeric in numeric ge (>=) at Makefile.PL line
59.
Configuring DBD::Oracle for perl 5.008008 on linux
(i486-linux-gnu-thread-multi)
Remember to actually *READ* the README file! Especially if you have any
problems.
Using Oracle in /usr/lib/oracle/xe/app/oracle/product/10.2.0/server
DEFINE _SQLPLUS_RELEASE = "1002000100" (CHAR)
Oracle version 10.2.0.1 (10.2)
Found /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/demo/demo_xe.mk
Using /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/demo/demo_xe.mk
Looks like Oracle XE
(/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/demo/demo_xe.mk)
Reading
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/demo/demo_xe.mk
Your LD_LIBRARY_PATH env var is set to
'/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib'
Checking for functioning wait.ph
Constant subroutine __USE_POSIX undefined
at /usr/lib/perl/5.8/features.ph line 8.
Constant subroutine __USE_POSIX2 undefined
at /usr/lib/perl/5.8/features.ph line 9.
Constant subroutine __USE_POSIX199309 undefined
at /usr/lib/perl/5.8/features.ph line 10.
Constant subroutine __USE_POSIX199506 undefined
at /usr/lib/perl/5.8/features.ph line 11.
Constant subroutine __USE_XOPEN undefined
at /usr/lib/perl/5.8/features.ph line 12.
Constant subroutine __USE_XOPEN_EXTENDED undefined
at /usr/lib/perl/5.8/features.ph line 13.
Constant subroutine __USE_UNIX98 undefined
at /usr/lib/perl/5.8/features.ph line 14.
Constant subroutine __USE_LARGEFILE undefined
at /usr/lib/perl/5.8/features.ph line 16.
Constant subroutine __USE_LARGEFILE64 undefined
at /usr/lib/perl/5.8/features.ph line 17.
Constant subroutine __USE_FILE_OFFSET64 undefined
at /usr/lib/perl/5.8/features.ph line 18.
Constant subroutine __USE_BSD undefined at /usr/lib/perl/5.8/features.ph
line 19.
Constant subroutine __USE_SVID undefined
at /usr/lib/perl/5.8/features.ph line 20.
Constant subroutine __USE_MISC undefined
at /usr/lib/perl/5.8/features.ph line 21.
Constant subroutine __USE_GNU undefined at /usr/lib/perl/5.8/features.ph
line 23.
Constant subroutine __USE_REENTRANT undefined
at /usr/lib/perl/5.8/features.ph line 24.
Constant subroutine _POSIX_SOURCE undefined
at /usr/lib/perl/5.8/features.ph line 49.
Constant subroutine _POSIX_C_SOURCE undefined
at /usr/lib/perl/5.8/features.ph line 51.
Constant subroutine _XOPEN_SOURCE undefined
at /usr/lib/perl/5.8/features.ph line 53.
Constant subroutine _XOPEN_SOURCE_EXTENDED undefined
at /usr/lib/perl/5.8/features.ph line 55.
Constant subroutine _LARGEFILE64_SOURCE undefined
at /usr/lib/perl/5.8/features.ph line 57.
Constant subroutine _LARGEFILE_SOURCE undefined
at /usr/lib/perl/5.8/features.ph line 104.
Constant subroutine __USE_ISOC99 undefined
at /usr/lib/perl/5.8/features.ph line 108.
Constant subroutine __GNU_LIBRARY__ undefined
at /usr/lib/perl/5.8/features.ph line 156.
Constant subroutine __need_size_t undefined
at /usr/lib/perl/5.8/stddef.ph line 148.
Unquoted string "typedef" may clash with future reserved word at (eval
180) line 1.
Operator or semicolon missing before &typedef at (eval 180) line 1.
Ambiguous use of & resolved as operator & at (eval 180) line 1.
Constant subroutine __need_timeval undefined
at /usr/lib/perl/5.8/bits/time.ph line 23.
System: perl5.008008 linux rothera 2.6.15.7 #1 smp tue jun 27 18:34:43
utc 2006 i686 gnulinux
Compiler: cc -O2 -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS
-DDEBIAN -fno-strict-aliasing -pipe -I/usr/local/include
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64
Linker: /usr/bin/ld
Sysliblist: -ldl -lm -lpthread -lnsl -lirc
Oracle makefiles would have used these definitions but we override them:
CC: /usr/bin/g++296
LDFLAGS: -g
[-g]
Linking with -L/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/
-lclntsh -lpthread
LD_RUN_PATH=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib
Using DBD::Oracle 1.19.
Using DBD::Oracle 1.19.
Using DBI 1.51 (for perl 5.008008 on i486-linux-gnu-thread-multi)
installed in /usr/lib/perl5/auto/DBI/
Writing Makefile for DBD::Oracle
*** If you have problems...
read all the log printed above, and the README and README.help.txt
files.
(Of course, you have read README by now anyway, haven't you?)
[EMAIL PROTECTED]:~/usr/src/DBD-Oracle-1.19-RC3$ make
cp Oracle.pm blib/lib/DBD/Oracle.pm
Skip blib/lib/DBD/mkta.pl (unchanged)
Skip blib/lib/oraperl.ph (unchanged)
Skip blib/arch/auto/DBD/Oracle/dbdimp.h (unchanged)
Skip blib/arch/auto/DBD/Oracle/ocitrace.h (unchanged)
Skip blib/lib/Oraperl.pm (unchanged)
Skip blib/arch/auto/DBD/Oracle/Oracle.h (unchanged)
cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm
Skip blib/lib/DBD/Oracle/GetInfo.pm (unchanged)
cc -c -I/usr/lib/perl5/auto/DBI
-I/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/public/
-DLINUX -D_GNU_SOURCE -D_REENTRANT -g -D_REENTRANT -D_GNU_SOURCE
-DTHREADS_HAVE_PIDS -DDEBIAN -fno-strict-aliasing -pipe
-I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2
-DVERSION=\"1.19\" -DXS_VERSION=\"1.19\" -fPIC
"-I/usr/lib/perl/5.8/CORE" -Wall -Wno-comment -DUTF8_SUPPORT
-DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.1\" Oracle.c
cc -c -I/usr/lib/perl5/auto/DBI
-I/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/public/
-DLINUX -D_GNU_SOURCE -D_REENTRANT -g -D_REENTRANT -D_GNU_SOURCE
-DTHREADS_HAVE_PIDS -DDEBIAN -fno-strict-aliasing -pipe
-I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2
-DVERSION=\"1.19\" -DXS_VERSION=\"1.19\" -fPIC
"-I/usr/lib/perl/5.8/CORE" -Wall -Wno-comment -DUTF8_SUPPORT
-DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.1\" dbdimp.c
dbdimp.c: In function ‘ora_db_login6’:
dbdimp.c:700: warning: value computed is not used
dbdimp.c: In function ‘dbd_rebind_ph_char’:
dbdimp.c:1110: warning: value computed is not used
dbdimp.c: In function ‘ora_st_execute_array’:
dbdimp.c:2157: warning: value computed is not used
dbdimp.c:2681:2: warning: no newline at end of file
dbdimp.c: At top level:
dbdimp.c:1862: warning: ‘ora_st_bind_for_array_exec’ defined but not
used
cc -c -I/usr/lib/perl5/auto/DBI
-I/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/public/
-DLINUX -D_GNU_SOURCE -D_REENTRANT -g -D_REENTRANT -D_GNU_SOURCE
-DTHREADS_HAVE_PIDS -DDEBIAN -fno-strict-aliasing -pipe
-I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2
-DVERSION=\"1.19\" -DXS_VERSION=\"1.19\" -fPIC
"-I/usr/lib/perl/5.8/CORE" -Wall -Wno-comment -DUTF8_SUPPORT
-DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.1\" oci8.c
oci8.c: In function ‘fetch_func_rset’:
oci8.c:652: warning: value computed is not used
oci8.c: In function ‘dbd_rebind_ph_lob’:
oci8.c:748: warning: value computed is not used
oci8.c:779: warning: value computed is not used
oci8.c: In function ‘post_execute_lobs’:
oci8.c:2246: warning: value computed is not used
Running Mkbootstrap for DBD::Oracle ()
chmod 644 Oracle.bs
rm -f blib/arch/auto/DBD/Oracle/Oracle.so
LD_RUN_PATH="/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib" cc
-shared -L/usr/local/lib Oracle.o dbdimp.o oci8.o -o
blib/arch/auto/DBD/Oracle/Oracle.so \
-L/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/
-lclntsh -lpthread \
chmod 755 blib/arch/auto/DBD/Oracle/Oracle.so
cp Oracle.bs blib/arch/auto/DBD/Oracle/Oracle.bs
chmod 644 blib/arch/auto/DBD/Oracle/Oracle.bs
/usr/bin/perl "-Iblib/arch" "-Iblib/lib" ora_explain.PL ora_explain
Extracted ora_explain from ora_explain.PL with variable substitutions.
cp ora_explain blib/script/ora_explain
/usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)"
blib/script/ora_explain
Manifying blib/man1/ora_explain.1p
Manifying blib/man3/DBD::Oracle.3pm
Manifying blib/man3/DBD::Oraperl.3pm
[EMAIL PROTECTED]:~/usr/src/DBD-Oracle-1.19-RC3$ make test
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e"
"test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/01base................ok
t/10general.............ok
t/15nls.................ok
t/20select..............ok
t/21nchar............... Database and client versions and character
sets:
Database 10.2.0.1.0 CHAR set is WE8MSWIN1252 (Non-Unicode), NCHAR set is
AL16UTF16 (Unicode)
Client 10.2.0.1 NLS_LANG is '<unset>', NLS_NCHAR is '<unset>'
t/21nchar...............ok
t/22nchar_al32utf8......ok
t/22nchar_utf8..........ok
t/23wide_db.............skipped
all skipped: Database character set is not Unicode
t/23wide_db_8bit........skipped
all skipped: Database character set is not Unicode
t/23wide_db_al32utf8....skipped
all skipped: Database character set is not Unicode
t/24implicit_utf8.......ok
t/25plsql...............ok
t/26exe_array...........ok
t/30long................ok
122/470 skipped: various reasons
t/31lob.................ok
t/40ph_type.............ok 1/19 Placeholder behaviour for ora_type=1
(the default) varies with Oracle version.
Oracle 7 didn't strip trailing spaces, Oracle 8 did, until 9.2.x
Your system doesn't. If that seems odd, let us know.
t/40ph_type.............ok
t/50cursor..............ok
t/55nested..............ok
t/60reauth..............ORACLE_USERID_2 not defined. Tests skipped.
skipped
all skipped: no reason given
t/70meta................ok
All tests successful, 4 tests and 122 subtests skipped.
Files=20, Tests=1925, 25 wallclock secs ( 6.01 cusr + 0.53 csys = 6.54
CPU)
PERL_DL_NONLAZY=1 /usr/bin/perl "-Iblib/lib" "-Iblib/arch" test.pl
Oraperl emulation interface version 1.44
DBD::Oracle 1.19 using OCI10.2.0.1 by Tim Bunce
DBI 1.52 by Tim Bunce
Data sources:
dbi:Oracle:XE
Connecting
to '' (from command line, else uses ORACLE_SID or TWO_TASK -
recommended)
as 'tvilliers/xxx' (via ORACLE_USERID env var or default - recommend
name/[EMAIL PROTECTED])
(ORACLE_SID='XE', TWO_TASK='')
Fields: 6
Names: NUM_T DATE_T CHAR_T ROWID_T RAW_T NULL_T
Lengths: 172 76 31 21 3 1
OraTypes: 2 12 1 104 23 1
SQLTypes: 8 93 12 -9104 -2 12
Scale: 0 0 0 0 0 0
Precision: 126 75 30 20 2 0
Nullable: 1 1 1 '' 1 1
Est row width: 32
Data rows:
fetch: '7.2', '30-OCT-06', 'TVILLIERS', 'AAAAECAABAAAAgiAAA', '7D',
undef
Repetitive connect/open/close/disconnect:
1 2 3 4 5 6 7 8 9 10 (~0.082 seconds each)
test.pl complete.
