On Fri, 08 Jan 2010 14:55:51 -0500, John Scoles <sco...@pythian.com> wrote:
> Well here it is the second crack at 1.24 Beer version of DBD::ORACLE > > > You can find the release candidate here > > http://svn.perl.org/modules/dbd-oracle/trunk/DBD-Oracle-1.24-RC2.tar t/31lob.t still fails :( > this time out I have hopefully fixed most of the warnings > > I have also updated the pod to explain what ora_ncs_buff_mtpl and var > ORA_DBD_NCS_BUFFER do > > I have also added a few other little patches from H.Merijn Brand > > The big one this RC is that I think I finally got the RowsInCache and > RowCacheSize working according to spec > > RowCacheSize can now be set on the statement handle (in the prepare) > > and RowsInCache has been implemented as a Read only value off the > statement handle as well > > Both the Statement and the DB handle versions of RowsInCache also now > decrement correctly (nothing fancy in the change just moved the > decrement later on in the code path) > > Hope this cleans any bugs up. > > cheers > and thanks for the testing DBD-Oracle-svn 103 > perl Makefile.PL Using DBI 1.609 (for perl 5.010001 on x86_64-linux) installed in /pro/lib/perl5/site_perl/5.10.1/x86_64-linux/auto/DBI/ Configuring DBD::Oracle for perl 5.010001 on linux (x86_64-linux) 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.2 DEFINE _SQLPLUS_RELEASE = "1102000002" (CHAR) Oracle version 11.2.0.0 (11.2) Found /usr/share/oracle/11.2/client64/demo.mk Using /usr/share/oracle/11.2/client64/demo.mk Your LD_LIBRARY_PATH env var is set to '/pro/oracle/v11.2/lib' Reading /usr/share/oracle/11.2/client64/demo.mk WARNING: Oracle /usr/share/oracle/11.2/client64/demo.mk doesn't define a 'build' rule. 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 sensitive. It is possible that it won't be supported in future versions of DBD::Oracle. *PLEASE* notify dbi-users about exactly _why_ you had to build it this way. Found header files in /usr/include/oracle/11.2/client64. Checking for functioning wait.ph System: perl5.010001 linux pc09 2.6.27.23-0.1-default #1 smp 2009-05-26 17:02:05 -0400 x86_64 x86_64 x86_64 gnulinux Compiler: ccache cc -O2 -fPIC -fno-strict-aliasing -pipe -fstack-protector -I/pro/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/g++ LDFLAGS: -g [-g] Linking with -L../../ -locci -lclntsh -lpthread [from $(CCLIB)] WARNING: If you have problems you may need to rebuild perl with threading enabled. Warning: -L../../ changed to -L/pro/3gl/CPAN/DBD-Oracle-svn/../../ LD_RUN_PATH=/pro/oracle/v11.2/lib Using DBD::Oracle 1.23. Using DBD::Oracle 1.23. Using DBI 1.609 (for perl 5.010001 on x86_64-linux) installed in /pro/lib/perl5/site_perl/5.10.1/x86_64-linux/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?) DBD-Oracle-svn 104 > make test Skip blib/lib/DBD/Oracle.pm (unchanged) cp lib/DBD/.svn/entries blib/lib/DBD/.svn/entries cp lib/.svn/entries blib/lib/.svn/entries Skip blib/lib/oraperl.ph (unchanged) Skip blib/arch/auto/DBD/Oracle/Oracle.h (unchanged) Skip blib/lib/DBD/.svn/all-wcprops (unchanged) Skip blib/lib/DBD/Oracle/.svn/text-base/GetInfo.pm.svn-base (unchanged) Skip blib/lib/DBD/Oracle/.svn/prop-base/GetInfo.pm.svn-base (unchanged) Skip blib/lib/DBD/Oracle/GetInfo.pm (unchanged) Skip blib/lib/.svn/format (unchanged) Skip blib/lib/DBD/Oracle/.svn/format (unchanged) Skip blib/lib/DBD/Oracle/.svn/text-base/Object.pm.svn-base (unchanged) Skip blib/lib/.svn/all-wcprops (unchanged) cp lib/DBD/Oracle/.svn/entries blib/lib/DBD/Oracle/.svn/entries Skip blib/lib/DBD/.svn/format (unchanged) cp dbdimp.h blib/arch/auto/DBD/Oracle/dbdimp.h Skip blib/lib/DBD/Oracle/.svn/all-wcprops (unchanged) Skip blib/arch/auto/DBD/Oracle/ocitrace.h (unchanged) Skip blib/lib/Oraperl.pm (unchanged) Skip blib/lib/DBD/Oracle/Object.pm (unchanged) Skip blib/arch/auto/DBD/Oracle/mk.pm (unchanged) ccache cc -g -c -I/usr/include/oracle/11.2/client64 -I/pro/lib/perl5/site_perl/5.10.1/x86_64-linux/auto/DBI -g -fPIC -fno-strict-aliasing -pipe -fstack-protector -I/pro/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -DVERSION=\"1.23\" -DXS_VERSION=\"1.23\" -fPIC "-I/pro/lib/perl5/5.10.1/x86_64-linux/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"11.2.0.0\" -Wall -Wcast-align -Wpointer-arith -Wbad-function-cast -Wcast-qual Oracle.c ccache cc -g -c -I/usr/include/oracle/11.2/client64 -I/pro/lib/perl5/site_perl/5.10.1/x86_64-linux/auto/DBI -g -fPIC -fno-strict-aliasing -pipe -fstack-protector -I/pro/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -DVERSION=\"1.23\" -DXS_VERSION=\"1.23\" -fPIC "-I/pro/lib/perl5/5.10.1/x86_64-linux/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"11.2.0.0\" -Wall -Wcast-align -Wpointer-arith -Wbad-function-cast -Wcast-qual dbdimp.c dbdimp.c: In function ‘ora_db_login6’: dbdimp.c:546: warning: format ‘%d’ expects type ‘int’, but argument 8 has type ‘size_t’ dbdimp.c:553: warning: format ‘%d’ expects type ‘int’, but argument 8 has type ‘size_t’ dbdimp.c:765: warning: format ‘%p’ expects type ‘void *’, but argument 6 has type ‘long int’ dbdimp.c:793: warning: format ‘%p’ expects type ‘void *’, but argument 6 has type ‘long int’ dbdimp.c: In function ‘dbd_rebind_ph_varchar2_table’: dbdimp.c:1679: warning: format ‘%p’ expects type ‘void *’, but argument 6 has type ‘long int’ dbdimp.c:1711: warning: format ‘%p’ expects type ‘void *’, but argument 6 has type ‘long int’ dbdimp.c:1720: warning: format ‘%p’ expects type ‘void *’, but argument 6 has type ‘long int’ dbdimp.c: In function ‘dbd_rebind_ph_number_table’: dbdimp.c:2086: warning: format ‘%p’ expects type ‘void *’, but argument 6 has type ‘long int’ dbdimp.c: In function ‘dbd_rebind_ph’: dbdimp.c:2689: warning: format ‘%p’ expects type ‘void *’, but argument 6 has type ‘long int’ dbdimp.c:2721: warning: format ‘%p’ expects type ‘void *’, but argument 6 has type ‘long int’ dbdimp.c:2730: warning: cast from function call of type ‘char *’ to non-matching type ‘long int’ dbdimp.c:2730: warning: format ‘%p’ expects type ‘void *’, but argument 6 has type ‘long int’ dbdimp.c: In function ‘do_bind_array_exec’: dbdimp.c:3243: warning: format ‘%p’ expects type ‘void *’, but argument 6 has type ‘long int’ dbdimp.c:3294: warning: format ‘%p’ expects type ‘void *’, but argument 6 has type ‘long int’ ccache cc -g -c -I/usr/include/oracle/11.2/client64 -I/pro/lib/perl5/site_perl/5.10.1/x86_64-linux/auto/DBI -g -fPIC -fno-strict-aliasing -pipe -fstack-protector -I/pro/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -DVERSION=\"1.23\" -DXS_VERSION=\"1.23\" -fPIC "-I/pro/lib/perl5/5.10.1/x86_64-linux/CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"11.2.0.0\" -Wall -Wcast-align -Wpointer-arith -Wbad-function-cast -Wcast-qual oci8.c oci8.c:986:3: warning: "/*" within comment oci8.c: In function ‘dbd_rebind_ph_lob’: oci8.c:1449: warning: format ‘%p’ expects type ‘void *’, but argument 6 has type ‘long int’ oci8.c: In function ‘fetch_lob’: oci8.c:1875: warning: format ‘%lu’ expects type ‘long unsigned int’, but argument 4 has type ‘ub4’ oci8.c: In function ‘get_object’: oci8.c:2243: warning: cast from pointer to integer of different size oci8.c:2243: warning: cast from pointer to integer of different size oci8.c: In function ‘sth_set_row_cache’: oci8.c:2775: warning: format ‘%p’ expects type ‘void *’, but argument 6 has type ‘long int’ oci8.c:2785: warning: format ‘%p’ expects type ‘void *’, but argument 6 has type ‘long int’ oci8.c: In function ‘ora_describe’: oci8.c:3580: warning: format ‘%p’ expects type ‘void *’, but argument 6 has type ‘long int’ oci8.c:3082: warning: unused variable ‘has_lobs’ oci8.c: In function ‘ora_parse_uid’: oci8.c:3884: warning: format ‘%p’ expects type ‘void *’, but argument 6 has type ‘long int’ oci8.c:3888: warning: format ‘%p’ expects type ‘void *’, but argument 6 has type ‘long int’ Running Mkbootstrap for DBD::Oracle () chmod 644 Oracle.bs rm -f blib/arch/auto/DBD/Oracle/Oracle.so LD_RUN_PATH="/pro/oracle/v11.2/lib" ccache cc -shared -O2 -L/pro/local/lib -fstack-protector Oracle.o dbdimp.o oci8.o -g -o blib/arch/auto/DBD/Oracle/Oracle.so \ -L/pro/oracle/v11.2/lib -L/pro/3gl/CPAN/DBD-Oracle-svn/../.. -locci -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.010001 not configured to support 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 ............... 1/11 DBD::Oracle::st execute failed: ORA-24813: cannot send or receive an unsupported LOB (DBD ERROR: OCIStmtExecute) [for Statement "BEGIN ? := DBMS_LOB.GETLENGTH( ? ); END;" with ParamValues: :p1=undef, :p2=OCILobLocatorPtr=SCALAR(0xc560b8)] at t/31lob.t line 123. t/31lob.t ............... 8/11 t/31lob.t ............... Dubious, test returned 1 (wstat 256, 0x100) Failed 4/11 subtests t/31lob_extended.t ...... ok t/32xmltype.t ........... ok t/34pres_lobs.t ......... ok t/40ph_type.t ........... 1/19 Placeholder behaviour for ora_type=1 VARCHAR2 (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.t ........... ok t/50cursor.t ............ ok t/51scroll.t ............ ok t/55nested.t ............ ok t/56embbeded.t .......... ok t/58object.t ............ ok 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: 8 Failed: 1) Failed test: 8 Non-zero exit status: 1 Parse errors: Bad plan. You planned 11 tests but ran 8. Files=30, Tests=2094, 20 wallclock secs ( 0.43 usr 0.11 sys + 5.56 cusr 0.91 csys = 7.01 CPU) Result: FAIL Failed 1/30 test programs. 1/2094 subtests failed. make: *** [test_dynamic] Error 255 -- H.Merijn Brand http://tux.nl Perl Monger http://amsterdam.pm.org/ using & porting perl 5.6.2, 5.8.x, 5.10.x, 5.11.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/
