test DBD::Oracle 1.16rc7 on HP-UX 11.00 and Oracle 8.1.7.0 (server and client
the same revision) using perl 5.6.1
Works, but only if I apply the following patch. Regards, Silvio
--- 31lob.t~ Tue Jul 13 01:22:34 2004
+++ 31lob.t Mon Sep 13 12:34:00 2004
@@ -3,3 +3,3 @@
use strict;
-use Test::More qw(no_plan);
+use Test::More tests => 2;
use DBD::Oracle qw(:ora_types);
t/01base............
t/01base............ok 1/5
t/01base............ok 2/5
t/01base............ok 3/5
t/01base............ok 4/5
t/01base............ok 5/5
t/01base............ok
t/10general.........
t/10general.........ok 1/31
t/10general.........ok 2/31
t/10general.........ok 3/31
t/10general.........ok 4/31
t/10general.........ok 5/31
t/10general.........ok 6/31
t/10general.........ok 7/31
t/10general.........ok 8/31
t/10general.........ok 9/31
t/10general.........ok 10/31
t/10general.........ok 11/31
t/10general.........ok 12/31
t/10general.........ok 13/31
t/10general.........ok 14/31
t/10general.........ok 15/31
t/10general.........ok 16/31
t/10general.........ok 17/31
t/10general.........ok 18/31
t/10general.........ok 19/31
t/10general.........ok 20/31
t/10general.........ok 21/31
t/10general.........ok 22/31
t/10general.........ok 23/31
t/10general.........ok 24/31
t/10general.........ok 25/31
t/10general.........ok 26/31
t/10general.........ok 27/31
t/10general.........ok 28/31
t/10general.........ok 29/31
t/10general.........ok 30/31
t/10general.........ok 31/31
t/10general.........ok
t/15nls.............
t/15nls.............ok 1/9
t/15nls.............ok 2/9
t/15nls.............ok 3/9
t/15nls.............ok 4/9
t/15nls.............ok 5/9
t/15nls.............ok 6/9
t/15nls.............ok 7/9
t/15nls.............ok 8/9
t/15nls.............ok 9/9
t/15nls.............ok
t/20select..........
t/20select..........ok 1/35
t/20select..........ok 2/35
t/20select..........ok 3/35
t/20select..........ok 4/35
t/20select..........ok 5/35
t/20select..........ok 6/35
t/20select..........ok 7/35
t/20select..........ok 8/35
t/20select..........ok 9/35
t/20select..........ok 10/35
t/20select..........ok 11/35
t/20select..........ok 12/35
t/20select..........ok 13/35
t/20select..........ok 14/35
t/20select..........ok 15/35
t/20select..........ok 16/35
t/20select..........ok 17/35
t/20select..........ok 18/35
t/20select..........ok 19/35
t/20select..........ok 20/35
t/20select..........ok 21/35
t/20select..........ok 22/35
t/20select..........ok 23/35
t/20select..........ok 24/35
t/20select..........ok 25/35
t/20select..........ok 26/35
t/20select..........ok 27/35
t/20select..........ok 28/35
t/20select..........ok 29/35
t/20select..........ok 30/35
t/20select..........ok 31/35
t/20select..........ok 32/35
t/20select..........ok 33/35
t/20select..........ok 34/35
t/20select..........ok 35/35
t/20select..........ok
t/21nchar........... Database and client versions and character sets:
Database 8.1.7.4.0 CHAR set is US7ASCII (Non-Unicode), NCHAR set is US7ASCII
(Non-Unicode)
Client 8.1.7.0 NLS_LANG is '<unset>', NLS_NCHAR is '<unset>'
skipped: Oracle charset tests unreliable for Oracle 8 client
t/22nchar_al32utf8..skipped: Oracle charset tests unreliable for Oracle 8 client
t/22nchar_utf8......skipped: Oracle charset tests unreliable for Oracle 8 client
t/23wide_db.........skipped: Oracle charset tests unreliable for Oracle 8 client
t/23wide_db_8bit....skipped: Oracle charset tests unreliable for Oracle 8 client
t/23wide_db_al32utf8.skipped: Oracle charset tests unreliable for Oracle 8 client
t/24implicit_utf8...skipped: Oracle charset tests unreliable for Oracle 8 client
t/25plsql...........
t/25plsql...........ok 1/67
t/25plsql...........ok 2/67
t/25plsql...........ok 3/67
t/25plsql...........ok 4/67
t/25plsql...........ok 5/67
t/25plsql...........ok 6/67
t/25plsql...........ok 7/67
t/25plsql...........ok 8/67
t/25plsql...........ok 9/67
t/25plsql...........ok 10/67
t/25plsql...........ok 11/67
t/25plsql...........ok 12/67
t/25plsql...........ok 13/67
t/25plsql...........ok 14/67
t/25plsql...........ok 15/67
t/25plsql...........ok 16/67
t/25plsql...........ok 17/67
t/25plsql...........ok 18/67
t/25plsql...........ok 19/67
t/25plsql...........ok 20/67
t/25plsql...........ok 21/67
t/25plsql...........ok 22/67
t/25plsql...........ok 23/67
t/25plsql...........ok 24/67
t/25plsql...........ok 25/67
t/25plsql...........ok 26/67
t/25plsql...........ok 27/67
t/25plsql...........ok 28/67
t/25plsql...........ok 29/67
t/25plsql...........ok 30/67
t/25plsql...........ok 31/67
t/25plsql...........ok 32/67
t/25plsql...........ok 33/67
t/25plsql...........ok 34/67
t/25plsql...........ok 35/67
t/25plsql...........ok 36/67
t/25plsql...........ok 37/67
t/25plsql...........ok 38/67
t/25plsql...........ok 39/67
t/25plsql...........ok 40/67
t/25plsql...........ok 41/67
t/25plsql...........ok 42/67
t/25plsql...........ok 43/67
t/25plsql...........ok 44/67
t/25plsql...........ok 45/67
t/25plsql...........ok 46/67
t/25plsql...........ok 47/67
t/25plsql...........ok 48/67
t/25plsql...........ok 49/67
t/25plsql...........ok 50/67
t/25plsql...........ok 51/67
t/25plsql...........ok 52/67
t/25plsql...........ok 53/67
t/25plsql...........ok 54/67
t/25plsql...........ok 55/67
t/25plsql...........ok 56/67
t/25plsql...........ok 57/67
t/25plsql...........ok 58/67
t/25plsql...........ok 59/67
t/25plsql...........ok 60/67
t/25plsql...........ok 61/67
t/25plsql...........ok 62/67
t/25plsql...........ok 63/67
t/25plsql...........ok 64/67
t/25plsql...........ok 65/67
t/25plsql...........ok 66/67
t/25plsql...........ok 67/67
t/25plsql...........ok
t/30long............
t/30long............ok 1/368
t/30long............ok 2/368
t/30long............ok 3/368
t/30long............ok 4/368
t/30long............ok 5/368
t/30long............ok 6/368
t/30long............ok 7/368
t/30long............ok 8/368
t/30long............ok 9/368
t/30long............ok 10/368
t/30long............ok 11/368
t/30long............ok 12/368
t/30long............ok 13/368
t/30long............ok 14/368
t/30long............ok 15/368
t/30long............ok 16/368
t/30long............ok 17/368
t/30long............ok 18/368
t/30long............ok 19/368
t/30long............ok 20/368
t/30long............ok 21/368
t/30long............ok 22/368
t/30long............ok 23/368
t/30long............ok 24/368
t/30long............ok 25/368
t/30long............ok 26/368
t/30long............ok 27/368
t/30long............ok 28/368
t/30long............ok 29/368
t/30long............ok 30/368
t/30long............ok 31/368
t/30long............ok 32/368
t/30long............ok 33/368
t/30long............ok 34/368
t/30long............ok 35/368
t/30long............ok 36/368
t/30long............ok 37/368
t/30long............ok 38/368
t/30long............ok 39/368
t/30long............ok 40/368
t/30long............ok 41/368
t/30long............ok 42/368
t/30long............ok 43/368
t/30long............ok 44/368
t/30long............ok 45/368
t/30long............ok 46/368
t/30long............ok 47/368
t/30long............ok 48/368
t/30long............ok 49/368
t/30long............ok 50/368
t/30long............ok 51/368
t/30long............ok 52/368
t/30long............ok 53/368
t/30long............ok 54/368
t/30long............ok 55/368
t/30long............ok 56/368
t/30long............ok 57/368
t/30long............ok 58/368
t/30long............ok 59/368
t/30long............ok 60/368
t/30long............ok 61/368
t/30long............ok 62/368
t/30long............ok 63/368
t/30long............ok 64/368
t/30long............ok 65/368
t/30long............ok 66/368
t/30long............ok 67/368
t/30long............ok 68/368
t/30long............ok 69/368
t/30long............ok 70/368
t/30long............ok 71/368
t/30long............ok 72/368
t/30long............ok 73/368
t/30long............ok 74/368
t/30long............ok 75/368
t/30long............ok 76/368
t/30long............ok 77/368
t/30long............ok 78/368
t/30long............ok 79/368
t/30long............ok 80/368
t/30long............ok 81/368
t/30long............ok 82/368
t/30long............ok 83/368
t/30long............ok 84/368
t/30long............ok 85/368
t/30long............ok 86/368
t/30long............ok 87/368
t/30long............ok 88/368
t/30long............ok 89/368
t/30long............ok 90/368
t/30long............ok 91/368
t/30long............ok 92/368
t/30long............ok 93/368
t/30long............ok 94/368
t/30long............ok 95/368
t/30long............ok 96/368
t/30long............ok 97/368
t/30long............ok 98/368
t/30long............ok 99/368
t/30long............ok 100/368
t/30long............ok 101/368
t/30long............ok 102/368
t/30long............ok 103/368
t/30long............ok 104/368
t/30long............ok 105/368
t/30long............ok 106/368
t/30long............ok 107/368
t/30long............ok 108/368
t/30long............ok 109/368
t/30long............ok 110/368
t/30long............ok 111/368
t/30long............ok 112/368
t/30long............ok 113/368
t/30long............ok 114/368
t/30long............ok 115/368
t/30long............ok 116/368
t/30long............ok 117/368
t/30long............ok 118/368
t/30long............ok 119/368
t/30long............ok 120/368
t/30long............ok 121/368
t/30long............ok 122/368
t/30long............ok 123/368
t/30long............ok 124/368
t/30long............ok 125/368
t/30long............ok 126/368
t/30long............ok 127/368
t/30long............ok 128/368
t/30long............ok 129/368
t/30long............ok 130/368
t/30long............ok 131/368
t/30long............ok 132/368
t/30long............ok 133/368
t/30long............ok 134/368
t/30long............ok 135/368
t/30long............ok 136/368
t/30long............ok 137/368
t/30long............ok 138/368
t/30long............ok 139/368
t/30long............ok 140/368
t/30long............ok 141/368
t/30long............ok 142/368
t/30long............ok 143/368
t/30long............ok 144/368
t/30long............ok 145/368
t/30long............ok 146/368
t/30long............ok 147/368
t/30long............ok 148/368
t/30long............ok 149/368
t/30long............ok 150/368
t/30long............ok 151/368
t/30long............ok 152/368
t/30long............ok 153/368
t/30long............ok 154/368
t/30long............ok 155/368
t/30long............ok 156/368
t/30long............ok 157/368
t/30long............ok 158/368
t/30long............ok 159/368
t/30long............ok 160/368
t/30long............ok 161/368
t/30long............ok 162/368
t/30long............ok 163/368
t/30long............ok 164/368
t/30long............ok 165/368
t/30long............ok 166/368
t/30long............ok 167/368
t/30long............ok 168/368
t/30long............ok 169/368
t/30long............ok 170/368
t/30long............ok 171/368
t/30long............ok 172/368
t/30long............ok 173/368
t/30long............ok 174/368
t/30long............ok 175/368
t/30long............ok 176/368
t/30long............ok 177/368
t/30long............ok 178/368
t/30long............ok 179/368
t/30long............ok 180/368
t/30long............ok 181/368
t/30long............ok 182/368
t/30long............ok 183/368
t/30long............ok 184/368
t/30long............ok 185/368
t/30long............ok 186/368
t/30long............ok 187/368
t/30long............ok 188/368
t/30long............ok 189/368
t/30long............ok 190/368
t/30long............ok 191/368
t/30long............ok 192/368
t/30long............ok 193/368
t/30long............ok 194/368
t/30long............ok 195/368
t/30long............ok 196/368
t/30long............ok 197/368
t/30long............ok 198/368
t/30long............ok 199/368
t/30long............ok 200/368
t/30long............ok 201/368
t/30long............ok 202/368
t/30long............ok 203/368
t/30long............ok 204/368
t/30long............ok 205/368
t/30long............ok 206/368
t/30long............ok 207/368
t/30long............ok 208/368
t/30long............ok 209/368
t/30long............ok 210/368
t/30long............ok 211/368
t/30long............ok 212/368
t/30long............ok 213/368
t/30long............ok 214/368
t/30long............ok 215/368
t/30long............ok 216/368
t/30long............ok 217/368
t/30long............ok 218/368
t/30long............ok 219/368
t/30long............ok 220/368
t/30long............ok 221/368
t/30long............ok 222/368
t/30long............ok 223/368
t/30long............ok 224/368
t/30long............ok 225/368
t/30long............ok 226/368
t/30long............ok 227/368
t/30long............ok 228/368
t/30long............ok 229/368
t/30long............ok 230/368
t/30long............ok 231/368
t/30long............ok 232/368
t/30long............ok 233/368
t/30long............ok 234/368
t/30long............ok 235/368
t/30long............ok 236/368
t/30long............ok 237/368
t/30long............ok 238/368
t/30long............ok 239/368
t/30long............ok 240/368
t/30long............ok 241/368
t/30long............ok 242/368
t/30long............ok 243/368
t/30long............ok 244/368
t/30long............ok 245/368
t/30long............ok 246/368
t/30long............ok 247/368
t/30long............ok 248/368
t/30long............ok 249/368
t/30long............ok 250/368
t/30long............ok 251/368
t/30long............ok 252/368
t/30long............ok 253/368
t/30long............ok 254/368
t/30long............ok 255/368
t/30long............ok 256/368
t/30long............ok 257/368
t/30long............ok 258/368
t/30long............ok 259/368
t/30long............ok 260/368
t/30long............ok 261/368
t/30long............ok 262/368
t/30long............ok 263/368
t/30long............ok 264/368
t/30long............ok 265/368
t/30long............ok 266/368
t/30long............ok 267/368
t/30long............ok 268/368
t/30long............ok 269/368
t/30long............ok 270/368
t/30long............ok 271/368
t/30long............ok 272/368
t/30long............ok 273/368
t/30long............ok 274/368
t/30long............ok 275/368
t/30long............ok 276/368
t/30long............ok 277/368
t/30long............ok 278/368
t/30long............ok 279/368
t/30long............ok 280/368
t/30long............ok 281/368
t/30long............ok 282/368
t/30long............ok 283/368
t/30long............ok 284/368
t/30long............ok 285/368
t/30long............ok 286/368
t/30long............ok 287/368
t/30long............ok 288/368
t/30long............ok 289/368
t/30long............ok 290/368
t/30long............ok 291/368
t/30long............ok 292/368
t/30long............ok 293/368
t/30long............ok 294/368
t/30long............ok 295/368
t/30long............ok 296/368
t/30long............ok 297/368
t/30long............ok 298/368
t/30long............ok 299/368
t/30long............ok 300/368
t/30long............ok 301/368
t/30long............ok 302/368
t/30long............ok 303/368
t/30long............ok 304/368
t/30long............ok 305/368
t/30long............ok 306/368
t/30long............ok 307/368
t/30long............ok 308/368
t/30long............ok 309/368
t/30long............ok 310/368
t/30long............ok 311/368
t/30long............ok 312/368
t/30long............ok 313/368
t/30long............ok 314/368
t/30long............ok 315/368
t/30long............ok 316/368
t/30long............ok 317/368
t/30long............ok 318/368
t/30long............ok 319/368
t/30long............ok 320/368
t/30long............ok 321/368
t/30long............ok 322/368
t/30long............ok 323/368
t/30long............ok 324/368
t/30long............ok 325/368
t/30long............ok 326/368
t/30long............ok 327/368
t/30long............ok 328/368
t/30long............ok 329/368
t/30long............ok 330/368
t/30long............ok 331/368
t/30long............ok 332/368
t/30long............ok 333/368
t/30long............ok 334/368
t/30long............ok 335/368
t/30long............ok 336/368
t/30long............ok 337/368
t/30long............ok 338/368
t/30long............ok 339/368
t/30long............ok 340/368
t/30long............ok 341/368
t/30long............ok 342/368
t/30long............ok 343/368
t/30long............ok 344/368
t/30long............ok 345/368
t/30long............ok 346/368
t/30long............ok 347/368
t/30long............ok 348/368
t/30long............ok 349/368
t/30long............ok 350/368
t/30long............ok 351/368
t/30long............ok 352/368
t/30long............ok 353/368
t/30long............ok 354/368
t/30long............ok 355/368
t/30long............ok 356/368
t/30long............ok 357/368
t/30long............ok 358/368
t/30long............ok 359/368
t/30long............ok 360/368
t/30long............ok 361/368
t/30long............ok 362/368
t/30long............ok 363/368
t/30long............ok 364/368
t/30long............ok 365/368
t/30long............ok 366/368
t/30long............ok 367/368
t/30long............ok 368/368
t/30long............ok, 124/368 skipped: various reasons
t/31lob.............
t/31lob.............ok 1/2
t/31lob.............ok 2/2
t/31lob.............ok
t/40ph_type.........
t/40ph_type.........ok 1/19
t/40ph_type.........ok 2/19
t/40ph_type.........ok 3/19
t/40ph_type.........ok 4/19
t/40ph_type.........ok 5/19
t/40ph_type.........ok 6/19
t/40ph_type.........ok 7/19
t/40ph_type.........ok 8/19
t/40ph_type.........ok 9/19
t/40ph_type.........ok 10/19
t/40ph_type.........ok 11/19
t/40ph_type.........ok 12/19
t/40ph_type.........ok 13/19
t/40ph_type.........ok 14/19
t/40ph_type.........ok 15/19
t/40ph_type.........ok 16/19
t/40ph_type.........ok 17/19
t/40ph_type.........ok 18/19
t/40ph_type.........ok 19/19
t/40ph_type.........ok
t/50cursor..........
t/50cursor..........ok 1/12
t/50cursor..........ok 2/12
t/50cursor..........ok 3/12
t/50cursor..........ok 4/12
t/50cursor..........ok 5/12
t/50cursor..........ok 6/12
t/50cursor..........ok 7/12
t/50cursor..........ok 8/12
t/50cursor..........ok 9/12
t/50cursor..........ok 10/12
t/50cursor..........ok 11/12
t/50cursor..........ok 12/12
t/50cursor..........ok
t/60reauth..........skipped test on this platform
t/70meta............
t/70meta............ok 1/11
t/70meta............ok 2/11
t/70meta............ok 3/11
t/70meta............ok 4/11
t/70meta............ok 5/11
t/70meta............ok 6/11
t/70meta............ok 7/11
t/70meta............ok 8/11
t/70meta............ok 9/11
t/70meta............ok 10/11
t/70meta............ok 11/11
t/70meta............ok
All tests successful, 8 tests and 124 subtests skipped.
Files=18, Tests=559, 64 wallclock secs (16.75 cusr + 5.76 csys = 22.51 CPU)
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 OCI8.1.7.0 by Tim Bunce
DBI 1.42 by Tim Bunce
Data sources:
...
Connecting
to '' (from command line, else uses ORACLE_SID or TWO_TASK - recommended)
as 'guest/guest' (via ORACLE_USERID env var or default - recommend name/[EMAIL
PROTECTED])
Fields: 6
Names: 'NUM_T' 'DATE_T' 'CHAR_T' 'ROWID_T' 'RAW_T'
'NULL_T'
Lengths: 134 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: 32
Data rows:
fetch: '7.2', '13-SEP-04', 'GUEST', 'AAAADDAABAAAAHSAAA', '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 1 seconds.
Test complete (7 seconds).
If the tests above have produced the 'expected' output then they have passed.
