Part of the changes look for Unix-style shared libraries which doesn't cover Windows instant client; here's a patch that tweaks enough to get it to build, and logs of Windows-native and Cygwin builds and tests.
Both done against the following instant client zips unpacked to d:\lib\instantclient_10_2: instantclient-basic-win32-10.2.0.1-20050930.zip instantclient-sdk-win32-10.2.0.1-20050930.zip instantclient-sqlplus-win32-10.2.0.1-20050930.zip The changes in the patch are: (1) Also look for oci.dll in the place where libclntsh.so.10.1 is checked for the ORACLE_HOME validity check. (2) Modified the MSWin32/cygwin-specific OCIDIR search to be able to use the 'sdk' subdirectory from the instant client. (3) Fix a bug in the statement that checks for sqlplus.exe vs. sqlplus - it was looking for $^O eq 'Win32' when it's really 'MSWin32'. With these it compiles and runs; not 100% test passes, but I believe these are existing issues in the latest revision of DBD::Oracle and not due to the makefile changes. -- Andy Hassall :: [EMAIL PROTECTED] :: http://www.andyh.co.uk http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool > -----Original Message----- > From: John Scoles [mailto:[EMAIL PROTECTED] > Sent: 06 October 2005 12:35 > To: [email protected] > Subject: DBD Oracle & Instantclient 10 > > I am looking for volunteers testers for a new version of the > Makefile.PL for Oracle Instantclient 10. > > You can find it at > http://svn.perl.org/modules/dbd-oracle/branches/pythian > > This version has been tested on a Linux box but I would like > to see how it performs on other environments. > > Any feedback you may have would be very much appreciated. > > TXs
[EMAIL PROTECTED] ~/src/pythian
$ export PATH="/cygdrive/d/lib/instantclient_10_2:$PATH"
[EMAIL PROTECTED] ~/src/pythian
$ which sqlplus
/cygdrive/d/lib/instantclient_10_2/sqlplus
[EMAIL PROTECTED] ~/src/pythian
$ export ORACLE_HOME=d:/lib/instantclient_10_2
[EMAIL PROTECTED] ~/src/pythian
$ export NLS_LANG=.WE8ISO8859P15
[EMAIL PROTECTED] ~/src/pythian
$ export ORACLE_USERID=test/[EMAIL PROTECTED]
[EMAIL PROTECTED] ~/src/pythian
$ perl Makefile.PL
Using DBI 1.47 (for perl 5.008007 on cygwin-thread-multi-64int) installed in
/usr/lib/perl5/site_perl/5.8/cygwin/auto/DBI/
Configuring DBD::Oracle ...
>>> Remember to actually *READ* the README file!
Especially if you have any problems.
Using Oracle in d:/lib/instantclient_10_2
DEFINE _SQLPLUS_RELEASE = "1002000100" (CHAR)
Oracle version 10.2.0.1 (10.2)
Using OCI directory 'sdk'
Checking for functioning wait.ph
System: perl5.008007 cygwin_nt-5.1 inspiron 1.5.18(0.13242) 2005-07-02 20:30
i686 unknown unknown cygwin
Compiler: gcc -O3 -DPERL_USE_SAFE_PUTENV -fno-strict-aliasing -pipe
-I/usr/local/include
Linker: /usr/bin/ld
Sysliblist:
Checking if your kit is complete...
Warning: the following files are missing in your kit:
META.yml
Please inform the author.
LD_RUN_PATH=d:/lib/instantclient_10_2/lib:d:/lib/instantclient_10_2/rdbms/lib
Using DBD::Oracle 1.16.
Using DBD::Oracle 1.16.
Using DBI 1.47 (for perl 5.008007 on cygwin-thread-multi-64int) installed in
/usr/lib/perl5/site_perl/5.8/cygwin/auto/DBI/
Writing Makefile for DBD::Oracle
*** If you have problems...
read all the log printed above, and the README and README.help files.
(Of course, you have read README by now anyway, haven't you?)
[EMAIL PROTECTED] ~/src/pythian
$ make
cp Oracle.pm blib/lib/DBD/Oracle.pm
cp mkta.pl blib/lib/DBD/mkta.pl
cp oraperl.ph blib/lib/oraperl.ph
cp dbdimp.h blib/arch/auto/DBD/Oracle/dbdimp.h
cp ocitrace.h blib/arch/auto/DBD/Oracle/ocitrace.h
cp Oraperl.pm blib/lib/Oraperl.pm
cp Oracle.h blib/arch/auto/DBD/Oracle/Oracle.h
cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm
cp lib/DBD/Oracle/GetInfo.pm blib/lib/DBD/Oracle/GetInfo.pm
/usr/bin/perl.exe -p -e "s/~DRIVER~/Oracle/g"
/usr/lib/perl5/site_perl/5.8/cygwin/auto/DBI//Driver.xst > Oracle.xsi
/usr/bin/perl.exe /usr/lib/perl5/5.8/ExtUtils/xsubpp -typemap
/usr/lib/perl5/5.8/ExtUtils/typemap -typemap typemap Oracle.xs > Oracle.xsc &&
mv Oracle.xsc Oracle.c
gcc -g -c -Id:/lib/instantclient_10_2/sdk/include
-Id:/lib/instantclient_10_2/rdbms/demo
-I/usr/lib/perl5/site_perl/5.8/cygwin/auto/DBI/ -g -DPERL_USE_SAFE_PUTENV
-fno-strict-aliasing -pipe -I/usr/local/include -DUSEIMPORTLIB
-DVERSION=\"1.16\" -DXS_VERSION=\"1.16\" "-I/usr/lib/perl5/5.8/cygwin/CORE"
-Wall -Wno-comment -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.1\"
-Wall -Wcast-align -Wpointer-arith -Wbad-function-cast -Wcast-qual -Wconversion
Oracle.c
In file included from Oracle.c:85:
/usr/lib/perl5/site_perl/5.8/cygwin/auto/DBI/Driver_xst.h: In function
`dbdxst_bind_params':
/usr/lib/perl5/site_perl/5.8/cygwin/auto/DBI/Driver_xst.h:61: warning: passing
arg 2 of `Perl_newSViv' with different width due to prototype
/usr/lib/perl5/site_perl/5.8/cygwin/auto/DBI/Driver_xst.h:66: warning: passing
arg 3 of `Perl_sv_setiv' with different width due to prototype
/usr/lib/perl5/site_perl/5.8/cygwin/auto/DBI/Driver_xst.h:67: warning: passing
arg 5 of `ora_bind_ph' with different width due to prototype
/usr/lib/perl5/site_perl/5.8/cygwin/auto/DBI/Driver_xst.h:67: warning: passing
arg 8 of `ora_bind_ph' with different width due to prototype
/usr/lib/perl5/site_perl/5.8/cygwin/auto/DBI/Driver_xst.h: In function
`dbdxst_fetchall_arrayref':
/usr/lib/perl5/site_perl/5.8/cygwin/auto/DBI/Driver_xst.h:96: warning: passing
arg 3 of `Perl_av_extend' with different width due to prototype
Oracle.xsi: In function `XS_DBD__Oracle__st_rows':
Oracle.xsi:425: warning: passing arg 2 of `Perl_newSViv' with different width
due to prototype
Oracle.xsi: In function `XS_DBD__Oracle__st_bind_param':
Oracle.xsi:494: warning: passing arg 8 of `ora_bind_ph' with different width
due to prototype
Oracle.xsi: In function `XS_DBD__Oracle__st_execute':
Oracle.xsi:555: warning: passing arg 2 of `Perl_newSViv' with different width
due to prototype
Oracle.xs: In function `XS_DBD__Oracle__st_ora_fetch':
Oracle.xs:83: warning: passing arg 2 of `Perl_newSViv' with different width due
to prototype
Oracle.xs: In function `XS_DBD__Oracle__db_ora_lob_write':
Oracle.xs:167: warning: passing arg 8 of `OCILobWrite' with different width due
to prototype
Oracle.xs:167: warning: passing arg 11 of `OCILobWrite' with different width
due to prototype
Oracle.xs:167: warning: passing arg 12 of `OCILobWrite' with different width
due to prototype
Oracle.xs: In function `XS_DBD__Oracle__db_ora_lob_append':
Oracle.xs:221: warning: passing arg 7 of `OCILobWriteAppend' with different
width due to prototype
Oracle.xs:221: warning: passing arg 10 of `OCILobWriteAppend' with different
width due to prototype
Oracle.xs:221: warning: passing arg 11 of `OCILobWriteAppend' with different
width due to prototype
Oracle.xs:191: warning: unused variable `startp'
Oracle.xs: In function `XS_DBD__Oracle__db_ora_lob_read':
Oracle.xs:276: warning: passing arg 2 of `Perl_newSV' with different width due
to prototype
Oracle.xs:291: warning: passing arg 10 of `OCILobRead' with different width due
to prototype
Oracle.xs:291: warning: passing arg 11 of `OCILobRead' with different width due
to prototype
Oracle.xs: In function `XS_DBD__Oracle__db_ora_lob_trim':
Oracle.xs:317: warning: passing arg 4 of `OCILobTrim' with different width due
to prototype
Oracle.xs: In function `XS_DBD__Oracle__db_ora_lob_length':
Oracle.xs:341: warning: passing arg 2 of `Perl_newSVuv' with different width
due to prototype
Oracle.xsi: In function `boot_DBD__Oracle':
Oracle.xsi:21: warning: passing arg 3 of `Perl_sv_setiv' with different width
due to prototype
Oracle.xsi:22: warning: passing arg 3 of `Perl_sv_setiv' with different width
due to prototype
Oracle.xsi:23: warning: passing arg 3 of `Perl_sv_setiv' with different width
due to prototype
gcc -g -c -Id:/lib/instantclient_10_2/sdk/include
-Id:/lib/instantclient_10_2/rdbms/demo
-I/usr/lib/perl5/site_perl/5.8/cygwin/auto/DBI/ -g -DPERL_USE_SAFE_PUTENV
-fno-strict-aliasing -pipe -I/usr/local/include -DUSEIMPORTLIB
-DVERSION=\"1.16\" -DXS_VERSION=\"1.16\" "-I/usr/lib/perl5/5.8/cygwin/CORE"
-Wall -Wno-comment -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.1\"
-Wall -Wcast-align -Wpointer-arith -Wbad-function-cast -Wcast-qual -Wconversion
dbdimp.c
dbdimp.c: In function `dbd_discon_all':
dbdimp.c:119: warning: passing arg 4 of pointer to function with different
width due to prototype
dbdimp.c: In function `ora_db_login6':
dbdimp.c:276: warning: unused variable `o'
dbdimp.c:277: warning: unused variable `l'
dbdimp.c:308: warning: cast to pointer from integer of different size
dbdimp.c:322: warning: cast to pointer from integer of different size
dbdimp.c:332: warning: cast to pointer from integer of different size
dbdimp.c:336: warning: cast to pointer from integer of different size
dbdimp.c:386: warning: passing arg 3 of `OCINlsEnvironmentVariableGet' with
different width due to prototype
dbdimp.c:386: warning: passing arg 4 of `OCINlsEnvironmentVariableGet' with
different width due to prototype
dbdimp.c:393: warning: passing arg 3 of `OCINlsEnvironmentVariableGet' with
different width due to prototype
dbdimp.c:393: warning: passing arg 4 of `OCINlsEnvironmentVariableGet' with
different width due to prototype
dbdimp.c:420: warning: passing arg 9 of `OCIEnvNlsCreate' with different width
due to prototype
dbdimp.c:420: warning: passing arg 10 of `OCIEnvNlsCreate' with different width
due to prototype
dbdimp.c: In function `ora_db_STORE_attrib':
dbdimp.c:782: warning: passing arg 4 of `Perl_hv_store' as signed due to
prototype
dbdimp.c: In function `ora_db_FETCH_attrib':
dbdimp.c:802: warning: passing arg 2 of `Perl_newSViv' with different width due
to prototype
dbdimp.c:805: warning: passing arg 2 of `Perl_newSViv' with different width due
to prototype
dbdimp.c:808: warning: passing arg 2 of `Perl_newSViv' with different width due
to prototype
dbdimp.c:811: warning: passing arg 2 of `Perl_newSViv' with different width due
to prototype
dbdimp.c:814: warning: passing arg 2 of `Perl_newSViv' with different width due
to prototype
dbdimp.c:819: warning: passing arg 4 of `Perl_hv_fetch' as signed due to
prototype
dbdimp.c: In function `dbd_preparse':
dbdimp.c:947: warning: passing arg 4 of `Perl_hv_store' as signed due to
prototype
dbdimp.c: In function `dbd_rebind_ph_char':
dbdimp.c:1120: warning: cast from pointer to integer of different size
dbdimp.c: In function `pp_rebind_ph_rset_in':
dbdimp.c:1148: warning: passing arg 8 of `OCIBindByName' with different width
due to prototype
dbdimp.c: In function `pp_exec_rset':
dbdimp.c:1197: warning: passing arg 8 of `OCIBindByName' with different width
due to prototype
dbdimp.c: In function `dbd_rebind_ph':
dbdimp.c:1299: warning: passing arg 8 of `OCIBindByName' with different width
due to prototype
dbdimp.c: In function `ora_bind_ph':
dbdimp.c:1445: warning: passing arg 4 of `Perl_hv_fetch' as signed due to
prototype
dbdimp.c: In function `ora_st_blob_read':
dbdimp.c:1766: warning: passing arg 6 of `ora_blob_read_mb_piece' with
different width due to prototype
dbdimp.c:1773: warning: passing arg 6 of `ora_blob_read_piece' with different
width due to prototype
dbdimp.c: In function `ora_st_finish':
dbdimp.c:1841: warning: passing arg 4 of `OCIStmtFetch' with different width
due to prototype
dbdimp.c: In function `ora_st_STORE_attrib':
dbdimp.c:1979: warning: passing arg 4 of `Perl_hv_store' as signed due to
prototype
dbdimp.c: In function `ora_st_FETCH_attrib':
dbdimp.c:2042: warning: passing arg 2 of `Perl_newSViv' with different width
due to prototype
dbdimp.c:2048: warning: passing arg 2 of `Perl_newSViv' with different width
due to prototype
dbdimp.c:2054: warning: passing arg 2 of `Perl_newSViv' with different width
due to prototype
dbdimp.c:2060: warning: passing arg 2 of `Perl_newSViv' with different width
due to prototype
dbdimp.c:2071: warning: passing arg 2 of `Perl_newSViv' with different width
due to prototype
dbdimp.c:2084: warning: passing arg 4 of `Perl_hv_fetch' as signed due to
prototype
gcc -g -c -Id:/lib/instantclient_10_2/sdk/include
-Id:/lib/instantclient_10_2/rdbms/demo
-I/usr/lib/perl5/site_perl/5.8/cygwin/auto/DBI/ -g -DPERL_USE_SAFE_PUTENV
-fno-strict-aliasing -pipe -I/usr/local/include -DUSEIMPORTLIB
-DVERSION=\"1.16\" -DXS_VERSION=\"1.16\" "-I/usr/lib/perl5/5.8/cygwin/CORE"
-Wall -Wno-comment -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.1\"
-Wall -Wcast-align -Wpointer-arith -Wbad-function-cast -Wcast-qual -Wconversion
oci8.c
oci8.c: In function `oci_error_err':
oci8.c:176: warning: passing arg 4 of pointer to function with different width
due to prototype
oci8.c: In function `ora_st_prepare':
oci8.c:269: warning: passing arg 3 of `Perl_sv_setiv' with different width due
to prototype
oci8.c: In function `dbd_phs_out':
oci8.c:449: warning: passing arg 3 of `Perl_av_fetch' with different width due
to prototype
oci8.c: In function `fetch_func_varfield':
oci8.c:530: warning: passing arg 3 of `Perl_sv_setiv' with different width due
to prototype
oci8.c: In function `ora_blob_read_mb_piece':
oci8.c:780: warning: passing arg 10 of `OCILobRead' with different width due to
prototype
oci8.c:780: warning: passing arg 11 of `OCILobRead' with different width due to
prototype
oci8.c:795: warning: passing arg 2 of `ora_utf8_to_bytes' with different width
due to prototype
oci8.c: In function `ora_blob_read_piece':
oci8.c:914: warning: passing arg 10 of `OCILobRead' with different width due to
prototype
oci8.c:914: warning: passing arg 11 of `OCILobRead' with different width due to
prototype
oci8.c: In function `fetch_func_autolob':
oci8.c:986: warning: passing arg 3 of `Perl_sv_setiv' with different width due
to prototype
oci8.c:1032: warning: passing arg 4 of `OCILobFileOpen' with different width
due to prototype
oci8.c:1041: warning: passing arg 10 of `OCILobRead' with different width due
to prototype
oci8.c:1041: warning: passing arg 11 of `OCILobRead' with different width due
to prototype
oci8.c: In function `ora_describe':
oci8.c:1409: warning: passing arg 7 of `OCIDefineByPos' with different width
due to prototype
oci8.c: In function `ora_st_fetch':
oci8.c:1484: warning: passing arg 4 of `OCIStmtFetch' with different width due
to prototype
oci8.c: In function `init_lob_refetch':
oci8.c:1769: warning: passing arg 5 of `OCIDescribeAny' with different width
due to prototype
oci8.c:1769: warning: passing arg 6 of `OCIDescribeAny' with different width
due to prototype
oci8.c:1769: warning: passing arg 7 of `OCIDescribeAny' with different width
due to prototype
oci8.c:1788: warning: passing arg 5 of `OCIDescribeAny' with different width
due to prototype
oci8.c:1788: warning: passing arg 6 of `OCIDescribeAny' with different width
due to prototype
oci8.c:1788: warning: passing arg 7 of `OCIDescribeAny' with different width
due to prototype
oci8.c:1793: warning: passing arg 5 of `OCIDescribeAny' with different width
due to prototype
oci8.c:1793: warning: passing arg 6 of `OCIDescribeAny' with different width
due to prototype
oci8.c:1793: warning: passing arg 7 of `OCIDescribeAny' with different width
due to prototype
oci8.c:1823: warning: passing arg 5 of `OCIParamGet' as unsigned due to
prototype
oci8.c:1841: warning: passing arg 2 of `Perl_newSViv' with different width due
to prototype
oci8.c:1846: warning: passing arg 4 of `Perl_hv_store' as signed due to
prototype
oci8.c:1871: warning: passing arg 1 of `alloc_via_sv' with different width due
to prototype
oci8.c:1973: warning: passing arg 8 of `OCIBindByName' with different width due
to prototype
oci8.c:1987: warning: passing arg 4 of `Perl_hv_fetch' as signed due to
prototype
oci8.c:1998: warning: passing arg 7 of `OCIDefineByPos' with different width
due to prototype
oci8.c: In function `post_execute_lobs':
oci8.c:2087: warning: passing arg 8 of `OCILobWrite' with different width due
to prototype
oci8.c:2087: warning: passing arg 11 of `OCILobWrite' with different width due
to prototype
oci8.c:2087: warning: passing arg 12 of `OCILobWrite' with different width due
to prototype
oci8.c: At top level:
oci8.c:563: warning: 'fetch_func_nty' defined but not used
oci8.c:1095: warning: 'fbh_setup_getrefpv' defined but not used
Running Mkbootstrap for DBD::Oracle ()
chmod 644 Oracle.bs
rm -f blib/arch/auto/DBD/Oracle/Oracle.dll
LD_RUN_PATH="d:/lib/instantclient_10_2/lib:d:/lib/instantclient_10_2/rdbms/lib"
ld2 -s -L/usr/local/lib Oracle.o dbdimp.o oci8.o -g -o
blib/arch/auto/DBD/Oracle/Oracle.dll
/usr/lib/perl5/5.8/cygwin/CORE/libperl.dll.a -L/home/andyh/src/pythian -loci
gcc -shared -o Oracle.dll -Wl,--out-implib=libOracle.dll.a
-Wl,--export-all-symbols -Wl,--enable-auto-import -Wl,--stack,8388608
-Wl,--enable-auto-image-base \
-s -L/usr/local/lib Oracle.o dbdimp.o oci8.o -g
/usr/lib/perl5/5.8/cygwin/CORE/libperl.dll.a -L/home/andyh/src/pythian -loci
Creating library file: libOracle.dll.a
mv Oracle.dll libOracle.dll.a blib/arch/auto/DBD/Oracle/
chmod 755 blib/arch/auto/DBD/Oracle/Oracle.dll
cp Oracle.bs blib/arch/auto/DBD/Oracle/Oracle.bs
chmod 644 blib/arch/auto/DBD/Oracle/Oracle.bs
/usr/bin/perl.exe "-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.exe "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/ora_explain
[EMAIL PROTECTED] ~/src/pythian
$ make test
/usr/bin/perl.exe "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib',
'blib/arch')" t/*.t
t/01base................ok
t/10general.............ok
t/15nls.................ok
t/20select..............FAILED tests 37-38
Failed 2/38 tests, 94.74% okay
t/21nchar............... Database and client versions and character sets:
Database 10.2.0.1.0 CHAR set is WE8ISO8859P15 (Non-Unicode), NCHAR set is
AL16UTF16 (Unicode)
Client 10.2.0.1 NLS_LANG is '.WE8ISO8859P15', NLS_NCHAR is '<unset>'
t/21nchar...............ok
t/22nchar_al32utf8......ok 13/37
# Failed test (t/nchar_test_lib.pl at line 333)
# got: '191'
# expected: '226|152|186'
# Failed test (t/nchar_test_lib.pl at line 336)
# got: '¿'
# expected: '\x{263A}'
# row 4: DUMP(nch) = Typ=1 Len=2: 38,58
t/22nchar_al32utf8......NOK 34# Looks like you failed 2 tests of 37.
t/22nchar_al32utf8......dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 33-34
Failed 2/37 tests, 94.59% okay
t/22nchar_utf8..........ok 1/53
# Failed test (t/nchar_test_lib.pl at line 333)
# got: '191'
# expected: '226|152|186'
# Failed test (t/nchar_test_lib.pl at line 336)
# got: '¿'
# expected: '\x{263A}'
# row 4: DUMP(nch) = Typ=1 Len=2: 38,58
# Failed test (t/nchar_test_lib.pl at line 333)
# got: '191|191|191|191'
# expected: '240|144|140|132'
# Failed test (t/nchar_test_lib.pl at line 336)
# got: '¿¿¿¿'
# expected: '\x{10304}'
# row 5: DUMP(nch) = Typ=1 Len=8: 255,253,255,253,255,253,255,253
# Failed test (t/nchar_test_lib.pl at line 333)
# got: '191|191|191|191'
t/22nchar_utf8..........NOK 42# expected: '240|160|140|129'
# Failed test (t/nchar_test_lib.pl at line 336)
# got: '¿¿¿¿'
# expected: '\x{20301}'
# row 6: DUMP(nch) = Typ=1 Len=8: 255,253,255,253,255,253,255,253
t/22nchar_utf8..........NOK 50# Looks like you failed 6 tests of 53.
t/22nchar_utf8..........dubious
Test returned status 6 (wstat 1536, 0x600)
DIED. FAILED tests 41-42, 45-46, 49-50
Failed 6/53 tests, 88.68% okay
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 1/74
# Failed test (t/nchar_test_lib.pl at line 333)
# got: '191'
# expected: '226|152|186'
# Failed test (t/nchar_test_lib.pl at line 336)
# got: '¿'
# expected: '\x{263A}'
# row 4: DUMP(nch) = Typ=1 Len=2: 0,191
t/24implicit_utf8.......ok 38/74
# Failed test (t/nchar_test_lib.pl at line 333)
# got: '191'
# expected: '226|152|186'
# Failed test (t/nchar_test_lib.pl at line 336)
# got: '¿'
# expected: '\x{263A}'
# row 4: DUMP(nch) = Typ=1 Len=2: 0,191
t/24implicit_utf8.......NOK 71# Looks like you failed 4 tests of 74.
t/24implicit_utf8.......dubious
Test returned status 4 (wstat 1024, 0x400)
DIED. FAILED tests 33-34, 70-71
Failed 4/74 tests, 94.59% okay
t/25plsql...............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
Failed Test Stat Wstat Total Fail Failed List of Failed
-------------------------------------------------------------------------------
t/20select.t 38 2 5.26% 37-38
t/22nchar_al32utf8.t 2 512 37 2 5.41% 33-34
t/22nchar_utf8.t 6 1536 53 6 11.32% 41-42 45-46 49-50
t/24implicit_utf8.t 4 1024 74 4 5.41% 33-34 70-71
4 tests and 122 subtests skipped.
Failed 4/19 test scripts, 78.95% okay. 14/1902 subtests failed, 99.26% okay.
make: *** [test_dynamic] Error 14
DBD-Oracle-pythian-r1562-instantclient-mswin32.patch
Description: Binary data
Setting environment for using Microsoft Visual Studio .NET 2003 tools.
(If you have another version of Visual Studio or Visual C++ installed and wish
to use its tools from the command line, run vcvars32.bat for that version.)
C:\Documents and Settings\andyh>d:
D:\>cd cygwin\home\andyh\src\pythian
D:\cygwin\home\andyh\src\pythian>set ORACLE_HOME=d:\lib\instantclient_10_2
D:\cygwin\home\andyh\src\pythian>set NLS_LANG=.WE8ISO8859P15
D:\cygwin\home\andyh\src\pythian>set PATH=d:\lib\instantclient_10_2;D:\Program F
iles\Microsoft Visual Studio .NET 2003\Common7\IDE;D:\Program Files\Microsoft Vi
sual Studio .NET 2003\VC7\BIN;D:\Program Files\Microsoft Visual Studio .NET 2003
\Common7\Tools;D:\Program Files\Microsoft Visual Studio .NET 2003\Common7\Tools\
bin\prerelease;D:\Program Files\Microsoft Visual Studio .NET 2003\Common7\Tools\
bin;D:\Program Files\Microsoft Visual Studio .NET 2003\SDK\v1.1\bin;C:\WINNT\Mic
rosoft.NET\Framework\v1.1.4322;d:\Perl\bin\;C:\WINNT\system32;C:\WINNT;C:\WINNT\
System32\Wbem;D:\Program Files\Microsoft SDK\Bin;D:\Program Files\Microsoft SDK\
Bin\WinNT
D:\cygwin\home\andyh\src\pythian>set ORACLE_USERID=test/[EMAIL PROTECTED]
D:\cygwin\home\andyh\src\pythian>perl Makefile.PL
Using DBI 1.48 (for perl 5.008006 on MSWin32-x86-multi-thread) installed in d:/P
erl/site/lib/auto/DBI/
Configuring DBD::Oracle ...
>>> Remember to actually *READ* the README file!
Especially if you have any problems.
Using Oracle in d:/lib/instantclient_10_2
DEFINE _SQLPLUS_RELEASE = "1002000100" (CHAR)
Oracle version 10.2.0.1 (10.2)
Using OCI directory 'sdk'
Found sdk/lib/MSVC/oci.lib library
Found sdk/lib/MSVC/ociw32.lib library
Found sdk/lib/MSVC/oraocci10.lib library
Using sdk/lib/MSVC/OCI.lib
Checking for functioning wait.ph
System: perl5.008006
Compiler: cl -MD -Zi -DNDEBUG -O1 -nologo -Gf -W3 -MD -Zi -DNDEBUG -O1 -DWIN32
-D_CONSOLE -DNO_STRICT -DHAVE_DES_FCRYPT -DNO_HASH_SEED -DPERL_IMPLICIT_CONTEX
T -DPERL_IMPLICIT_SYS -DUSE_PERLIO -DPERL_MSVCRT_READFIX
Linker: not found
Sysliblist:
Checking if your kit is complete...
Warning: the following files are missing in your kit:
META.yml
Please inform the author.
Use of uninitialized value in substitution (s///) at Makefile.PL line 1561.
LD_RUN_PATH=d:/lib/instantclient_10_2/lib:d:/lib/instantclient_10_2/rdbms/lib
Using DBD::Oracle 1.16.
Using DBD::Oracle 1.16.
Using DBI 1.48 (for perl 5.008006 on MSWin32-x86-multi-thread) installed in d:/P
erl/site/lib/auto/DBI/
Writing Makefile for DBD::Oracle
*** If you have problems...
read all the log printed above, and the README and README.help files.
(Of course, you have read README by now anyway, haven't you?)
D:\cygwin\home\andyh\src\pythian>nmake
Microsoft (R) Program Maintenance Utility Version 7.10.3077
Copyright (C) Microsoft Corporation. All rights reserved.
cp Oracle.pm blib\lib\DBD\Oracle.pm
cp mkta.pl blib\lib\DBD\mkta.pl
cp oraperl.ph blib\lib/oraperl.ph
cp dbdimp.h blib\arch\auto\DBD\Oracle/dbdimp.h
cp ocitrace.h blib\arch\auto\DBD\Oracle/ocitrace.h
cp Oraperl.pm blib\lib/Oraperl.pm
cp Oracle.h blib\arch\auto\DBD\Oracle/Oracle.h
cp mk.pm blib\arch\auto\DBD\Oracle/mk.pm
cp lib/DBD/Oracle/GetInfo.pm blib\lib\DBD\Oracle\GetInfo.pm
D:\Perl\bin\perl.exe -p -e "s/~DRIVER~/Oracle/g" d:/Perl/site/lib/auto/D
BI//Driver.xst > Oracle.xsi
D:\Perl\bin\perl.exe D:\Perl\lib\ExtUtils\xsubpp -typemap D:\Perl\lib\E
xtUtils\typemap -typemap typemap Oracle.xs > Oracle.xsc && D:\Perl\bin\perl.exe
-MExtUtils::Command -e mv Oracle.xsc Oracle.c
cl -Zi -c -Id:/lib/instantclient_10_2/sdk/include -Id:/lib/instantclien
t_10_2/rdbms/demo -Id:/Perl/site/lib/auto/DBI/ -Zi -nologo -Gf -W3 -MD -Zi -DND
EBUG -DWIN32 -D_CONSOLE -DNO_STRICT -DHAVE_DES_FCRYPT -DNO_HASH_SEED -DPERL_IMP
LICIT_CONTEXT -DPERL_IMPLICIT_SYS -DUSE_PERLIO -DPERL_MSVCRT_READFIX -MD -Zi -DN
DEBUG -O1 -DVERSION=\"1.16\" -DXS_VERSION=\"1.16\" "-ID:\Perl\lib\CORE" -D
UTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.1\" Oracle.c
Oracle.c
c1 : warning C4349: /Gf is deprecated and will not be supported in future versio
ns of Visual C++; remove /Gf or use /GF instead
Oracle.xs(191) : warning C4101: 'startp' : unreferenced local variable
cl -Zi -c -Id:/lib/instantclient_10_2/sdk/include -Id:/lib/instantclien
t_10_2/rdbms/demo -Id:/Perl/site/lib/auto/DBI/ -Zi -nologo -Gf -W3 -MD -Zi -DND
EBUG -DWIN32 -D_CONSOLE -DNO_STRICT -DHAVE_DES_FCRYPT -DNO_HASH_SEED -DPERL_IMP
LICIT_CONTEXT -DPERL_IMPLICIT_SYS -DUSE_PERLIO -DPERL_MSVCRT_READFIX -MD -Zi -DN
DEBUG -O1 -DVERSION=\"1.16\" -DXS_VERSION=\"1.16\" "-ID:\Perl\lib\CORE" -D
UTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.1\" dbdimp.c
dbdimp.c
c1 : warning C4349: /Gf is deprecated and will not be supported in future versio
ns of Visual C++; remove /Gf or use /GF instead
dbdimp.c(1093) : warning C4018: '<' : signed/unsigned mismatch
dbdimp.c(1093) : warning C4018: '<' : signed/unsigned mismatch
cl -Zi -c -Id:/lib/instantclient_10_2/sdk/include -Id:/lib/instantclien
t_10_2/rdbms/demo -Id:/Perl/site/lib/auto/DBI/ -Zi -nologo -Gf -W3 -MD -Zi -DND
EBUG -DWIN32 -D_CONSOLE -DNO_STRICT -DHAVE_DES_FCRYPT -DNO_HASH_SEED -DPERL_IMP
LICIT_CONTEXT -DPERL_IMPLICIT_SYS -DUSE_PERLIO -DPERL_MSVCRT_READFIX -MD -Zi -DN
DEBUG -O1 -DVERSION=\"1.16\" -DXS_VERSION=\"1.16\" "-ID:\Perl\lib\CORE" -D
UTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.1\" oci8.c
oci8.c
c1 : warning C4349: /Gf is deprecated and will not be supported in future versio
ns of Visual C++; remove /Gf or use /GF instead
oci8.c(1354) : warning C4018: '>' : signed/unsigned mismatch
oci8.c(1373) : warning C4018: '>' : signed/unsigned mismatch
Running Mkbootstrap for DBD::Oracle ()
D:\Perl\bin\perl.exe -MExtUtils::Command -e chmod 644 Oracle.bs
D:\Perl\bin\perl.exe -MExtUtils::Mksymlists -e "Mksymlists('NAME'=>\"DB
D::Oracle\", 'DLBASE' => 'Oracle', 'DL_FUNCS' => { }, 'FUNCLIST' => [], 'IMPORT
S' => { }, 'DL_VARS' => []);"
link -out:blib\arch\auto\DBD\Oracle\Oracle.dll -dll -nologo -nodefaultli
b -debug -opt:ref,icf -libpath:"D:\Perl\lib\CORE" -machine:x86 Oracle.obj dbd
imp.obj oci8.obj -g D:\Perl\lib\CORE\perl58.lib d:\lib\instantclient_10_2\sdk\
LIB\MSVC\OCI.lib "D:\Program Files\Microsoft Visual Studio .NET 2003\VC7\LIB\old
names.lib" "D:\Program Files\Microsoft Visual Studio .NET 2003\VC7\LIB\kernel32.
lib" "D:\Program Files\Microsoft Visual Studio .NET 2003\VC7\PlatformSDK\lib\use
r32.lib" "D:\Program Files\Microsoft Visual Studio .NET 2003\VC7\PlatformSDK\lib
\gdi32.lib" "D:\Program Files\Microsoft Visual Studio .NET 2003\VC7\PlatformSDK\
lib\winspool.lib" "D:\Program Files\Microsoft Visual Studio .NET 2003\VC7\Platfo
rmSDK\lib\comdlg32.lib" "D:\Program Files\Microsoft Visual Studio .NET 2003\VC7\
PlatformSDK\lib\advapi32.lib" "D:\Program Files\Microsoft Visual Studio .NET 200
3\VC7\PlatformSDK\lib\shell32.lib" "D:\Program Files\Microsoft Visual Studio .NE
T 2003\VC7\PlatformSDK\lib\ole32.lib" "D:\Program Files\Microsoft Visual Studio
.NET 2003\VC7\PlatformSDK\lib\oleaut32.lib" "D:\Program Files\Microsoft Visual S
tudio .NET 2003\VC7\PlatformSDK\lib\netapi32.lib" "D:\Program Files\Microsoft Vi
sual Studio .NET 2003\VC7\PlatformSDK\lib\uuid.lib" "D:\Program Files\Microsoft
Visual Studio .NET 2003\VC7\PlatformSDK\lib\ws2_32.lib" "D:\Program Files\Micros
oft Visual Studio .NET 2003\VC7\PlatformSDK\lib\mpr.lib" "D:\Program Files\Micro
soft Visual Studio .NET 2003\VC7\PlatformSDK\lib\winmm.lib" "D:\Program Files\Mi
crosoft Visual Studio .NET 2003\VC7\PlatformSDK\lib\version.lib" "D:\Program Fil
es\Microsoft Visual Studio .NET 2003\VC7\PlatformSDK\lib\odbc32.lib" "D:\Program
Files\Microsoft Visual Studio .NET 2003\VC7\PlatformSDK\lib\odbccp32.lib" "D:\P
rogram Files\Microsoft Visual Studio .NET 2003\VC7\LIB\msvcrt.lib" -def:Oracle.d
ef
LINK : warning LNK4044: unrecognized option '/g'; ignored
Creating library blib\arch\auto\DBD\Oracle\Oracle.lib and object blib\arch\au
to\DBD\Oracle\Oracle.exp
D:\Perl\bin\perl.exe -MExtUtils::Command -e chmod 755 blib\arch\auto\DBD
\Oracle\Oracle.dll
D:\Perl\bin\perl.exe -MExtUtils::Command -e cp Oracle.bs blib\arch\auto\
DBD\Oracle\Oracle.bs
D:\Perl\bin\perl.exe -MExtUtils::Command -e chmod 644 blib\arch\auto\DBD
\Oracle\Oracle.bs
D:\Perl\bin\perl.exe ora_explain.PL ora_explain
Extracted ora_explain from ora_explain.PL with variable substitutions.
D:\Perl\bin\perl.exe -MExtUtils::Command -e cp ora_explain blib\script\o
ra_explain
pl2bat.bat blib\script\ora_explain
D:\cygwin\home\andyh\src\pythian>nmake test
Microsoft (R) Program Maintenance Utility Version 7.10.3077
Copyright (C) Microsoft Corporation. All rights reserved.
D:\Perl\bin\perl.exe "-MExtUtils::Command::MM" "-e" "test_harness(0, 'bl
ib\lib', 'blib\arch')" t/*.t
t/01base................ok
t/10general.............ok
t/15nls.................ok
t/20select..............FAILED tests 37-38
Failed 2/38 tests, 94.74% okay
t/21nchar............... Database and client versions and character sets:
Database 10.2.0.1.0 CHAR set is WE8ISO8859P15 (Non-Unicode), NCHAR set is AL16UT
F16 (Unicode)
Client 10.2.0.1 NLS_LANG is '.WE8ISO8859P15', 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/30long................ok
122/470 skipped: various reasons
t/31lob.................ok
t/40ph_type.............ok 1/19 Placeholder behaviour for ora_type=1 (the defaul
t) 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
Failed Test Stat Wstat Total Fail Failed List of Failed
-------------------------------------------------------------------------------
t/20select.t 38 2 5.26% 37-38
4 tests and 122 subtests skipped.
Failed 1/19 test scripts, 94.74% okay. 2/1902 subtests failed, 99.89% okay.
NMAKE : fatal error U1077: 'D:\Perl\bin\perl.exe' : return code '0xff'
Stop.
