On Wed, 11 Jan 2006 23:57:58 +0000, Tim Bunce <[EMAIL PROTECTED]> wrote:
> http://www.data-plan.com/public/DBD-Oracle-1.17-RC3.tar.gz > > "We're getting there". This one fixes the two issues raised against RC2 > (thanks Andy and Steffen). HP-UX 11.23, perl-5.8.7-dor/64, DBI 1.50, HP C-ANSI-C, Oracle-9.2.0.2 HP-UX 11.23/64 U rx1620/64 Itanium 2/1600(2) ia64 2037 Mb --8<--- Your LD_LIBRARY_PATH env var is set to '' Your LD_LIBRARY_PATH env var doesn't include '/pro/oracle/v920/lib' but probably needs to. -->8--- on HP-UX that is set in SHLIB_PATH. I think they should be treated equal # echo $SHLIB_PATH /pro/oracle/v920/lib:/pro/asql/o83F/bin:/pro/asql/o83F/lib:/usr/lib:/etc/opt/resmon/lib:/opt/gnome/lib:/pro/local/lib:/pro/oracle/v920/lib # I just discovered this week that the optimizer of the most recent HP C-ANSI-C on HP-UX 11.23 (version B.06.05) is broken. Perl itself won't build with +O2 or up, so the hints in perl now drop to +O1 perl-5.8.7-dor didn't have that problem, so we should still be safe here. Just to let you know. Some compile warnings: --8<--- cc -c -I/pro/oracle/v920/plsql/public -I/pro/oracle/v920/rdbms/public -I/pro/or acle/v920/rdbms/demo -I/pro/oracle/v920/rdbms/demo -I/pro/oracle/v920/rdbms/publ ic -I/pro/oracle/v920/plsql/public -I/pro/oracle/v920/network/public -I/pro/lib/ perl5/site_perl/5.8.7/IA64.ARCHREV_0-LP64/auto/DBI/ -Ae -DDEBUGGING +Z -z -D_HPU X_SOURCE -Wl,+vnocompatwarnings +DD64 -I/pro/local/include -D_LARGEFILE_SOURCE - D_FILE_OFFSET_BITS=64 +O2 +Onolimit -DVERSION=\"1.17\" -DXS_VERSION=\"1.17\" + Z "-I/pro/lib/perl5/5.8.7/IA64.ARCHREV_0-LP64/CORE" -DUTF8_SUPPORT -DNEW_OCI_IN IT -DORA_OCI_VERSION=\"9.2.0.2\" Oracle.c "Oracle.xs", line 271: warning #2550-D: variable "csid" was set but never used ub2 csid; ^ cc -c -I/pro/oracle/v920/plsql/public -I/pro/oracle/v920/rdbms/public -I/pro/or acle/v920/rdbms/demo -I/pro/oracle/v920/rdbms/demo -I/pro/oracle/v920/rdbms/publ ic -I/pro/oracle/v920/plsql/public -I/pro/oracle/v920/network/public -I/pro/lib/ perl5/site_perl/5.8.7/IA64.ARCHREV_0-LP64/auto/DBI/ -Ae -DDEBUGGING +Z -z -D_HPU X_SOURCE -Wl,+vnocompatwarnings +DD64 -I/pro/local/include -D_LARGEFILE_SOURCE - D_FILE_OFFSET_BITS=64 +O2 +Onolimit -DVERSION=\"1.17\" -DXS_VERSION=\"1.17\" + Z "-I/pro/lib/perl5/5.8.7/IA64.ARCHREV_0-LP64/CORE" -DUTF8_SUPPORT -DNEW_OCI_IN IT -DORA_OCI_VERSION=\"9.2.0.2\" dbdimp.c "dbdimp.c", line 1179: warning #2550-D: variable "sth_i" was set but never used SV *sth_i; ^ "dbdimp.c", line 45: warning #2550-D: variable "ora_login_nomsg" was set but never used static int ora_login_nomsg; /* don't fetch real login errmsg if true */ ^ cc -c -I/pro/oracle/v920/plsql/public -I/pro/oracle/v920/rdbms/public -I/pro/or acle/v920/rdbms/demo -I/pro/oracle/v920/rdbms/demo -I/pro/oracle/v920/rdbms/publ ic -I/pro/oracle/v920/plsql/public -I/pro/oracle/v920/network/public -I/pro/lib/ perl5/site_perl/5.8.7/IA64.ARCHREV_0-LP64/auto/DBI/ -Ae -DDEBUGGING +Z -z -D_HPU X_SOURCE -Wl,+vnocompatwarnings +DD64 -I/pro/local/include -D_LARGEFILE_SOURCE - D_FILE_OFFSET_BITS=64 +O2 +Onolimit -DVERSION=\"1.17\" -DXS_VERSION=\"1.17\" + Z "-I/pro/lib/perl5/5.8.7/IA64.ARCHREV_0-LP64/CORE" -DUTF8_SUPPORT -DNEW_OCI_IN IT -DORA_OCI_VERSION=\"9.2.0.2\" oci8.c "oci8.c", line 132: warning #2236-D: controlling expression is constant && OCIErrorGet_log_stat(errhp, recno, (text*)NULL, &eg_errcode, errbuf, ^ "oci8.c", line 562: warning #2177-D: function "fetch_func_nty" was declared but never referenced fetch_func_nty(SV *sth, imp_fbh_t *fbh, SV *dest_sv) ^ "oci8.c", line 1094: warning #2177-D: function "fbh_setup_getrefpv" was declared but never referenced fbh_setup_getrefpv(imp_fbh_t *fbh, int desc_t, char *bless) ^ -->8--- And now the good news: bev x1:/pro/3gl/CPAN/DBD-Oracle-1.17 126 > make test PERL_DL_NONLAZY=1 /pro/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 9.2.0.2.0 CHAR set is US7ASCII (Non-Unicode), NCHAR set is AL16UTF16 (Unicode) Client 9.2.0.2 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/30long................ok 122/470 skipped: various reasons t/31lob.................ok t/40ph_type.............ok 4/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=19, Tests=1902, 17 wallclock secs ( 6.72 cusr + 1.22 csys = 7.94 CPU) PERL_DL_NONLAZY=1 /pro/bin/perl "-Iblib/lib" "-Iblib/arch" test.pl Oraperl emulation interface version 1.44 DBD::Oracle 1.17 using OCI9.2.0.2 by Tim Bunce DBI 1.50 by Tim Bunce Data sources: dbi:Oracle:EXTPROC_CONNECTION_DATA dbi:Oracle:bevfin dbi:Oracle:bevtest dbi:Oracle:bistest dbi:Oracle:fintest dbi:Oracle:leptest Connecting to '' (from command line, else uses ORACLE_SID or TWO_TASK - recommended) as 'PROBEV/PROBEV' (via ORACLE_USERID env var or default - recommend name/[EMAIL PROTECTED]) (ORACLE_SID='bevtest', 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 1 Est row width: 36 Data rows: fetch: '7.2', '12-JAN-06', 'PROBEV', 'AAAADeAABAAAAZaAAA', '7D', undef Repetitive connect/open/close/disconnect: 1 2 3 4 5 6 7 8 9 10 (~0.074 seconds each) test.pl complete. bev x1:/pro/3gl/CPAN/DBD-Oracle-1.17 127 > > I'd be grateful for more, and wider, testing. Thanks! -- H.Merijn Brand Amsterdam Perl Mongers (http://amsterdam.pm.org/) using Perl 5.6.2, 5.8.0, 5.8.5, & 5.9.2 on HP-UX 10.20, 11.00 & 11.11, AIX 4.3 & 5.2, SuSE 9.2 & 9.3, and Cygwin. http://www.cmve.net/~merijn Smoking perl: http://www.test-smoke.org, perl QA: http://qa.perl.org reports to: [EMAIL PROTECTED], [email protected]
