On Wed 27 Oct 2004 16:44, Tim Bunce <[EMAIL PROTECTED]> wrote:
> On Wed, Oct 27, 2004 at 09:39:33AM +0200, H.Merijn Brand wrote:
> > On Fri 22 Oct 2004 23:36, Tim Bunce <[EMAIL PROTECTED]> wrote:
> > > file: $CPAN/authors/id/T/TI/TIMB/DBD-Oracle-1.16.tar.gz
> > > size: 235224 bytes
> > > md5: 9711550ed0ebfc743920a6a357ed717c
> >
> > I know you can't blame the test for not being able to create a table for the
> > reason this failure shows, but there might be a more user-friendly way to fail ...
>
> Yeap. Some tests behave better in that situation. Looks like those
> two need improving. Patches welcome! (I'd happily not touch DBD::Oracle
> for a few months after the pain of the last few months :)
Gosh how I hate Oracle ... But it works.
HP-UX 11.11/64 (11i) + Oracle-9.2.0/64 + perl-5.8.5-dor/64 + DBI-1.45
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.1.0 CHAR set is US7ASCII (Non-Unicode), NCHAR set is AL16UTF16 (U
nicode)
Client 9.2.0.1 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
t/50cursor..............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=18, Tests=1883, 21 wallclock secs (13.14 cusr + 1.23 csys = 14.37 CPU)
PERL_DL_NONLAZY=1 /pro/bin/perl "-Iblib/lib" "-Iblib/arch" test.pl
Extra tests. These are less formal and you need to read the output
to see if it looks reasonable and matches what the tests says is expected.
Oraperl emulation interface version 1.44
DBD::Oracle 1.16 using OCI9.2.0.1 by Tim Bunce
DBI 1.45 by Tim Bunce
Data sources:
dbi:Oracle:EXTPROC_CONNECTION_DATA
dbi:Oracle:bevtest
dbi:Oracle:bistest
dbi:Oracle:leptest
Connecting
to '' (from command line, else uses ORACLE_SID or TWO_TASK - recommended)
as 'PROLEP/PROLEP' (via ORACLE_USERID env var or default - recommend name/passw
[EMAIL PROTECTED])
(ORACLE_SID='leptest', 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', '28-OCT-04', 'PROLEP', 'AAAADeAABAAAAZaAAA', '7D', undef
ora_logoff...
lda out of scope...
Testing repetitive connect/open/close/disconnect:
If this test hangs then read the README.help file.
Expect sequence of digits, no other messages:
1 2 3 4 5
Test interaction of explicit close/logoff and implicit DESTROYs
Expect just 'done.', no other messages:
done.
Testing row cache (5).
Test completed in 0 seconds.
Test complete (0 seconds).
If the tests above have produced the 'expected' output then they have passed.
--
H.Merijn Brand Amsterdam Perl Mongers (http://amsterdam.pm.org/)
using perl-5.6.1, 5.8.0 & 633 on HP-UX 10.20 & 11.00, AIX 4.2, AIX 4.3,
WinNT 4, Win2K pro & WinCE 2.11 often with Tk800.024 &/| DBD-Unify
ftp://ftp.funet.fi/pub/languages/perl/CPAN/authors/id/H/HM/HMBRAND/
