On Fri, 23 Jul 2010 08:08:01 -0400, John Scoles <sco...@pythian.com> 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/