Re: ANNOUNCE: DBD::Oracle 1.25 Release Candidate

"H.Merijn Brand" <[email protected]>
Newsgroups gmane.comp.lang.perl.modules.dbi.sybase.devel
Message-ID <[email protected]>
On Fri, 23 Jul 2010 08:08:01 -0400, John Scoles <[email protected]>
wrote:

> Well story two of the  'two bit' version of DBD::Oracle 1.25
> 
> You can find release candidate 2 here
> 
> http://svn.perl.org/modules/dbd-oracle/trunk/DBD-Oracle-1.25-RC2.tar.gz
> 
> This one has some minor changes from Martin Evans, though I could not 
> find any issues with the Makfile.PL myself.
> and hopefully I got rid of the warning error in the .xs file for 
> OCILobLocatorIsInit_log_stat
> 
> And of course the usual bunch of POD changes.

New laptop, new install, so a nice opportunity to give it a try

Linux 2.6.34-12-desktop/#1  HP EliteBook 8540p Core(TM) i5 CPU M 540 @ 2.53GHz/2534(4) i686  3868 Mb

SQL*Plus: Release 11.2.0.1.0 Production on Mon Sep 6 15:44:48 2010

# rpm -qa | grep ^oracle | sort
oracle-instantclient11.2-basic-11.2.0.1.0-1.i386
oracle-instantclient11.2-devel-11.2.0.1.0-1.i386
oracle-instantclient11.2-jdbc-11.2.0.1.0-1.i386
oracle-instantclient11.2-odbc-11.2.0.1.0-1.i386
oracle-instantclient11.2-sqlplus-11.2.0.1.0-1.i386
oracle-instantclient11.2-tools-11.2.0.1.0-1.i386

This is perl 5, version 12, subversion 0 (v5.12.0) built for i686-linux-64int-ld



DBD-Oracle-1.25-RC2 408 > perl Makefile.PL
Using DBI 1.613 (for perl 5.012000 on i686-linux-64int-ld) installed in /pro/lib
/perl5/site_perl/5.12.0/i686-linux-64int-ld/auto/DBI/

Configuring DBD::Oracle for perl 5.012000 on linux (i686-linux-64int-ld)

Remember to actually *READ* the README file! Especially if you have any problems
.

Installing on a linux, Ver#2.6
Using Oracle in /pro/oracle/v11
DEFINE _SQLPLUS_RELEASE = "1102000100" (CHAR)
Oracle version 11.2.0.1 (11.2)
Found /usr/share/oracle/11.2/client/demo.mk
Using /usr/share/oracle/11.2/client/demo.mk
Your LD_LIBRARY_PATH env var is set to '/pro/oracle/v11/lib'
Reading /usr/share/oracle/11.2/client/demo.mk
WARNING: Oracle /usr/share/oracle/11.2/client/demo.mk doesn't define a 'build' r
ule.

WARNING: I will now try to guess how to build and link DBD::Oracle for you.
         This kind of guess work is very error prone and Oracle-version sensitiv
e.
         It is possible that it won't be supported in future versions of DBD::Or
acle.
         *PLEASE* notify dbi-users about exactly _why_ you had to build it this
way.

Found header files in /usr/include/oracle/11.2/client.

client_version=11.2


DEFINE= -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"11.2.0.1\" -DORA_O
CI_102 -DORA_OCI_112


Checking for functioning wait.ph


System: perl5.012000 linux nb09 2.6.31.12-0.2-default #1 smp 2010-03-16 21:25:39
 +0100 i686 i686 i386 gnulinux
Compiler:   cc -O2 -DDEBUGGING -fno-strict-aliasing -pipe -fstack-protector -I/p
ro/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64
Linker:     /usr/bin/ld
Sysliblist:
Oracle makefiles would have used these definitions but we override them:
  CC:       /usr/bin/gcc
  LDFLAGS:  -g $(MTYPE)
sh: shell: command not found
           [-g ]
Linking with  -L../../ -locci -lclntsh -lpthread [from $(CCLIB)]


WARNING: If you have problems you may need to rebuild perl with threading enable
d.
Warning: -L../../ changed to -L/pro/3gl/CPAN/DBD-Oracle-1.25-RC2/../../
LD_RUN_PATH=/pro/oracle/v11/lib
Using DBD::Oracle 1.25.
Using DBD::Oracle 1.25.
Using DBI 1.613 (for perl 5.012000 on i686-linux-64int-ld) installed in /pro/lib
/perl5/site_perl/5.12.0/i686-linux-64int-ld/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?)

lep tux09:/pro/3gl/CPAN/DBD-Oracle-1.25-RC2 404 > make test
Skip blib/lib/DBD/Oracle.pm (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)
Skip blib/lib/DBD/Oracle/Object.pm (unchanged)
Skip blib/arch/auto/DBD/Oracle/mk.pm (unchanged)
Skip blib/lib/DBD/Oracle/GetInfo.pm (unchanged)
cc -c  -I/usr/include/oracle/11.2/client  -I/pro/lib/perl5/site_perl/5.12.0/i686
-linux-64int-ld/auto/DBI -DDEBUGGING -fno-strict-aliasing -pipe -fstack-protecto
r -I/pro/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2   -DVERSIO
N=\"1.25\" -DXS_VERSION=\"1.25\" -fPIC "-I/pro/lib/perl5/5.12.0/i686-linux-64int
-ld/CORE"  -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"11.2.0.1\" -DOR
A_OCI_102 -DORA_OCI_112 Oracle.c
Oracle.xs: In function ‘XS_DBD__Oracle__db_ora_lob_is_init’:
Oracle.xs:486:2: warning: passing argument 4 of ‘OCILobLocatorIsInit’ makes poin
ter from integer without a cast
/usr/include/oracle/11.2/client/ociap.h:7375:9: note: expected ‘boolean *’ but a
rgument is of type ‘boolean’
cc -c  -I/usr/include/oracle/11.2/client  -I/pro/lib/perl5/site_perl/5.12.0/i686
-linux-64int-ld/auto/DBI -DDEBUGGING -fno-strict-aliasing -pipe -fstack-protecto
r -I/pro/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2   -DVERSIO
N=\"1.25\" -DXS_VERSION=\"1.25\" -fPIC "-I/pro/lib/perl5/5.12.0/i686-linux-64int
-ld/CORE"  -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"11.2.0.1\" -DOR
A_OCI_102 -DORA_OCI_112 dbdimp.c
dbdimp.c: In function ‘ora_db_login6’:
dbdimp.c:819:6: warning: pointer targets in passing argument 13 of ‘OCISessionPo
olCreate’ differ in signedness
/usr/include/oracle/11.2/client/ociap.h:11012:7: note: expected ‘OraText *’ but
argument is of type ‘char *’
dbdimp.c:924:1: warning: label ‘dbd_db_login6_out’ defined but not used
dbdimp.c: In function ‘dbd_rebind_ph_char’:
dbdimp.c:2442:3: warning: format ‘%ld’ expects type ‘long int’, but argument 5 h
as type ‘IV’
dbdimp.c:2509:20: warning: cast from pointer to integer of different size
dbdimp.c: In function ‘dbd_rebind_ph_xml’:
dbdimp.c:2707:17: warning: cast to pointer from integer of different size
dbdimp.c: In function ‘ora_bind_ph’:
dbdimp.c:3000:6: warning: format ‘%ld’ expects type ‘long int’, but argument 2 h
as type ‘IV’
dbdimp.c:3009:5: warning: format ‘%ld’ expects type ‘long int’, but argument 2 h
as type ‘IV’
dbdimp.c:3043:4: warning: format ‘%ld’ expects type ‘long int’, but argument 3 h
as type ‘IV’
cc -c  -I/usr/include/oracle/11.2/client  -I/pro/lib/perl5/site_perl/5.12.0/i686
-linux-64int-ld/auto/DBI -DDEBUGGING -fno-strict-aliasing -pipe -fstack-protecto
r -I/pro/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2   -DVERSIO
N=\"1.25\" -DXS_VERSION=\"1.25\" -fPIC "-I/pro/lib/perl5/5.12.0/i686-linux-64int
-ld/CORE"  -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"11.2.0.1\" -DOR
A_OCI_102 -DORA_OCI_112 oci8.c
oci8.c: In function ‘ora_blob_read_mb_piece’:
oci8.c:1645:4: warning: format ‘%ld’ expects type ‘long int’, but argument 6 has
 type ‘UV’
Running Mkbootstrap for DBD::Oracle ()
chmod 644 Oracle.bs
rm -f blib/arch/auto/DBD/Oracle/Oracle.so
LD_RUN_PATH="/pro/oracle/v11/lib" cc  -shared -O2 -L/pro/local/lib -fstack-prote
ctor Oracle.o dbdimp.o oci8.o  -o blib/arch/auto/DBD/Oracle/Oracle.so   \
           -L/pro/oracle/v11/lib -L/pro/3gl/CPAN/DBD-Oracle-1.25-RC2/../.. -locc
i -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
/pro/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
/pro/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/ora_explain
PERL_DL_NONLAZY=1 /pro/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0,
'blib/lib', 'blib/arch')" t/*.t
t/01base.t .............. # Test loading DBI, DBD::Oracle and version
t/01base.t .............. ok
t/10general.t ........... ok
t/12impdata.t ........... ok
t/14threads.t ........... skipped: this linux perl 5.012000 not configured to su
pport iThreads
t/15nls.t ............... ok
t/20select.t ............ ok
t/21nchar.t ............. ok
t/22nchar_al32utf8.t .... ok
t/22nchar_utf8.t ........ ok
t/23wide_db.t ........... skipped: Database character set is not Unicode
t/23wide_db_8bit.t ...... skipped: Database character set is not Unicode
t/23wide_db_al32utf8.t .. skipped: Database character set is not Unicode
t/24implicit_utf8.t ..... ok
t/25plsql.t ............. ok
t/26exe_array.t ......... ok
t/28array_bind.t ........ ok
t/30long.t .............. ok
t/31lob.t ............... Dubious, test returned 1 (wstat 256, 0x100)
Failed 7/12 subtests
t/31lob_extended.t ...... ok
t/32xmltype.t ........... ok
t/34pres_lobs.t ......... ok
t/36lob_leak.t .......... ok
t/40ph_type.t ........... 1/19  Placeholder behaviour for ora_type=1 VARCHAR2 (t
he 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.t ........... ok
t/50cursor.t ............ ok
t/51scroll.t ............ ok
t/55nested.t ............ ok
t/56embbeded.t .......... ok
t/58object.t ............ 6/51



t/58object.t ............ Dubious, test returned 4 (wstat 1024, 0x400)
Failed 4/51 subtests
t/60reauth.t ............ skipped: ORACLE_USERID_2 not defined.
t/70meta.t .............. ok
t/80ora_charset.t ....... skipped: Database is set up as US7ASCII

Test Summary Report
-------------------
t/31lob.t             (Wstat: 256 Tests: 5 Failed: 0)
  Non-zero exit status: 1
  Parse errors: Bad plan.  You planned 12 tests but ran 5.
t/58object.t          (Wstat: 1024 Tests: 51 Failed: 4)
  Failed tests:  27, 31, 33-34
  Non-zero exit status: 4
Files=31, Tests=2126, 24 wallclock secs ( 0.43 usr  0.04 sys +  4.68 cusr  0.55
csys =  5.70 CPU)
Result: FAIL
Failed 2/31 test programs. 4/2126 subtests failed.
make: *** [test_dynamic] Error 255


-- 
H.Merijn Brand  http://tux.nl      Perl Monger  http://amsterdam.pm.org/
using 5.00307 through 5.12 and porting perl5.13.x on HP-UX 10.20, 11.00,
11.11, 11.23, and 11.31, OpenSuSE 10.3, 11.0, and 11.1, AIX 5.2 and 5.3.
http://mirrors.develooper.com/hpux/           http://www.test-smoke.org/
http://qa.perl.org      http://www.goldmark.org/jeff/stupid-disclaimers/
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.