Tim Bunce wrote:
>
> Is it an alpha or a beta? Who knows? Probably more alpha than beta
> but it it what it is and you're welcome to hit on it.
Perl 5.6.1, MSWin32, Borland 5.5, Oracle 8.1.7
dmake test:
t\base.......ok
t\cursor.....ok
t\general....ok
t\long.......ok 53/372# failed test 60 at line 328.
t\long.......ok 58/372# failed test 68 at line 328.
t\long.......ok 62/372# failed test 76 at line 328.
t\long.......ok 70/372# failed test 86 at line 342.
# failed test 88 at line 342.
t\long.......ok 79/372# failed test 90 at line 342.
t\long.......ok 145/372# failed test 153 at line 328.
t\long.......ok 147/372# failed test 161 at line 328.
t\long.......ok 155/372# failed test 169 at line 328.
t\long.......ok 163/372# failed test 179 at line 342.
# failed test 181 at line 342.
t\long.......ok 171/372# failed test 183 at line 342.
t\long.......ok 343/372
Some tests for LONG data type handling failed. These are generally Oracle bugs.
Please report this to the dbi-users mailing list, and include the
Oracle version number of both the client and the server.
Please also include the output of the 'perl -V' command.
(If you can, please study t/long.t to investigate the cause.
Feel free to edit the tests to see what's happening in more detail.
Especially by adding trace() calls around the failing tests.
Run the tests manually using the command "perl -Mblib t/long.t")
Meanwhile, if the other tests have passed you can use DBD::Oracle.
t\long.......dubious
Test returned status 4 (wstat 1024, 0x400)
DIED. FAILED tests 60, 68, 76, 86, 88, 90, 153, 161, 169, 179, 181, 183
Failed 12/372 tests, 96.77% okay
t\meta.......ok
t\ph_type....ok
t\plsql......ok
t\reauth.....skipped test on this platform
t\select.....ok
Failed Test Stat Wstat Total Fail Failed List of Failed
-------------------------------------------------------------------------------
t\long.t 4 1024 372 12 3.23% 60 68 76 86 88 90 153 161 169 179
181 183
1 test skipped.
Failed 1/9 test scripts, 88.89% okay. 12/1490 subtests failed, 99.19% okay.
dmake.exe: Error code 32, while making 'test_dynamic'
--
Verbose output for t/long attached. Hints welcome!
BTW: I have a core dump after the last test. If I add
an '$dbh->disconnect;' to the END {}, it says
t\long....ok 372/372DBI::db=HASH(0x180be8c)->disconnect
invalidates 5 active statement handles (either destroy
statement handles or call finish on them before
disconnecting) at t\long.t line 380.
and still crashes ...
SteffenUsing C:/temp/DBD-Oracle-1.15/blib
t\long....create table dbd_ora__drop_me ( idx integer, lng LONG, dt date )
1..372
long_data0 length 10240
long_data1 length 81920
long_data2 length 71680
create table dbd_ora__drop_me ( idx integer, lng BLOB, dt date )
--- insert some BLOB data (ora_type 113)
ok 1
ok 2
ok 3
ok 4
ok 5
--- fetch BLOB data back again -- truncated - LongTruncOk == 1
LongReadLen 20, LongTruncOk 1
ok 6
ok 7
ok 8
ok 9
ok 10
ok 11
ok 12
ok 13
--- fetch BLOB data back again -- truncated - LongTruncOk == 0
LongReadLen 81910, LongTruncOk
ok 14
ok 15
ok 16
ok 17
ok 18
ok 19
--- fetch BLOB data back again -- complete - LongTruncOk == 0
LongReadLen 82920, LongTruncOk
ok 20
ok 21
ok 22
ok 23
ok 24
ok 25
ok 26
ok 27
--- fetch BLOB data back again -- via blob_read
ok 28
ok 29
ok 30
ok 31
ok 32
ok 33
ok 34
ok 35
ok 36
ok 37
ok 38
--- testing ora_auto_lob to access BLOB LobLocator
ok 39
40: OCILobLocatorPtr=SCALAR(0x22ad698)
ok 40
ok 41
ok 42
ok 43
41: OCILobLocatorPtr=SCALAR(0x22ad6bc)
ok 44
ok 45
ok 46
ok 47
42: OCILobLocatorPtr=SCALAR(0x22ad698)
ok 48
# failed test 60 at line 328.
ok 49
ok 50
ok 51
43: undef
ok 52
40 locator: OCILobLocatorPtr=SCALAR(0x22ad698)
ok 53
ok 54
# failed test 68 at line 328.
40 content: '040 foo!.X0.x.X0.x.X'
ok 55
ok 56
ok 57
ok 58
ok 59
not ok 60
error: ORA-24801: illegal parameter value in OCI lob function (DBD ERROR:
OCILobWriteAppend)
41 locator: OCILobLocatorPtr=SCALAR(0x22ad6bc)
ok 61
ok 62
# failed test 76 at line 328.
41 content: '041 foo!901234567890'
ok 63
ok 64
ok 65
ok 66
ok 67
not ok 68
error: ORA-24801: illegal parameter value in OCI lob function (DBD ERROR:
OCILobWriteAppend)
42 locator: OCILobLocatorPtr=SCALAR(0x22ad698)
ok 69
ok 70
42 content: '042 foo!cd2bcdefabcd'
# failed test 86 at line 342.
# failed test 88 at line 342.
ok 71
ok 72
ok 73
ok 74
ok 75
not ok 76
error: ORA-24801: illegal parameter value in OCI lob function (DBD ERROR:
OCILobWriteAppend)
43 locator: undef
ok 77
ok 78
ok 79
ok 80
# failed test 90 at line 342.
ok 81
ok 82
ok 83
round again to check the length...
ok 84
40 locator: OCILobLocatorPtr=SCALAR(0x22ad728)
ok 85
not ok 86
41 locator: OCILobLocatorPtr=SCALAR(0x22ad6bc)
ok 87
not ok 88
42 locator: OCILobLocatorPtr=SCALAR(0x22ad728)
ok 89
not ok 90
43 locator: undef
ok 91
ok 92
ok 93
long_data0 length 10240
long_data1 length 81920
long_data2 length 71680
create table dbd_ora__drop_me ( idx integer, lng CLOB, dt date )
--- insert some CLOB data (ora_type 112)
ok 94
ok 95
ok 96
ok 97
ok 98
--- fetch CLOB data back again -- truncated - LongTruncOk == 1
LongReadLen 20, LongTruncOk 1
ok 99
ok 100
ok 101
ok 102
ok 103
ok 104
ok 105
ok 106
--- fetch CLOB data back again -- truncated - LongTruncOk == 0
LongReadLen 81910, LongTruncOk
ok 107
ok 108
ok 109
ok 110
ok 111
ok 112
--- fetch CLOB data back again -- complete - LongTruncOk == 0
LongReadLen 82920, LongTruncOk
ok 113
ok 114
ok 115
ok 116
ok 117
ok 118
ok 119
ok 120
--- fetch CLOB data back again -- via blob_read
ok 121
ok 122
ok 123
ok 124
ok 125
ok 126
ok 127
ok 128
ok 129
ok 130
ok 131
--- testing ora_auto_lob to access CLOB LobLocator
ok 132
40: OCILobLocatorPtr=SCALAR(0x21e4874)
ok 133
ok 134
ok 135
ok 136
41: OCILobLocatorPtr=SCALAR(0x180c2c8)
# failed test 153 at line 328.
ok 137
ok 138
ok 139
ok 140
42: OCILobLocatorPtr=SCALAR(0x21e4874)
ok 141
ok 142
ok 143
ok 144
43: undef
ok 145
40 locator: OCILobLocatorPtr=SCALAR(0x21e4874)
ok 146
# failed test 161 at line 328.
ok 147
40 content: '040 foo!.X0.x.X0.x.X'
ok 148
ok 149
ok 150
ok 151
ok 152
not ok 153
error: ORA-24801: illegal parameter value in OCI lob function (DBD ERROR:
OCILobWriteAppend)
41 locator: OCILobLocatorPtr=SCALAR(0x180c2c8)
ok 154
ok 155
41 content: '041 foo!901234567890'
# failed test 169 at line 328.
ok 156
ok 157
ok 158
ok 159
ok 160
not ok 161
error: ORA-24801: illegal parameter value in OCI lob function (DBD ERROR:
OCILobWriteAppend)
42 locator: OCILobLocatorPtr=SCALAR(0x21e4874)
ok 162
ok 163
42 content: '042 foo!cd2bcdefabcd'
# failed test 179 at line 342.
# failed test 181 at line 342.
ok 164
ok 165
ok 166
ok 167
ok 168
not ok 169
error: ORA-24801: illegal parameter value in OCI lob function (DBD ERROR:
OCILobWriteAppend)
43 locator: undef
ok 170
ok 171
ok 172
ok 173
ok 174
ok 175
# failed test 183 at line 342.
ok 176
round again to check the length...
ok 177
40 locator: OCILobLocatorPtr=SCALAR(0x21e4880)
ok 178
not ok 179
41 locator: OCILobLocatorPtr=SCALAR(0x180c2c8)
ok 180
not ok 181
42 locator: OCILobLocatorPtr=SCALAR(0x21e4880)
ok 182
not ok 183
43 locator: undef
ok 184
ok 185
ok 186
long_data0 length 10240
long_data1 length 81920
long_data2 length 71680
create table dbd_ora__drop_me ( idx integer, lng LONG, dt date )
--- insert some LONG data (ora_type 0)
ok 187
ok 188
ok 189
ok 190
ok 191
--- fetch LONG data back again -- truncated - LongTruncOk == 1
LongReadLen 20, LongTruncOk 1
ok 192
ok 193
ok 194
ok 195
ok 196
ok 197
ok 198
ok 199
--- fetch LONG data back again -- truncated - LongTruncOk == 0
LongReadLen 81910, LongTruncOk
ok 200
ok 201
ok 202
ok 203
ok 204
ok 205
--- fetch LONG data back again -- complete - LongTruncOk == 0
LongReadLen 82920, LongTruncOk
ok 206
ok 207
ok 208
ok 209
ok 210
ok 211
ok 212
ok 213
--- fetch LONG data back again -- via blob_read
Skipped blob_read tests for LONGs with OCI8 - not currently supported.
ok 214
ok 215
ok 216
ok 217
ok 218
ok 219
ok 220
ok 221
ok 222
ok 223
ok 224
ok 225
ok 226
ok 227
ok 228
ok 229
ok 230
ok 231
ok 232
ok 233
ok 234
ok 235
ok 236
ok 237
ok 238
ok 239
ok 240
ok 241
ok 242
ok 243
ok 244
ok 245
ok 246
ok 247
ok 248
ok 249
ok 250
ok 251
ok 252
ok 253
ok 254
ok 255
ok 256
ok 257
ok 258
ok 259
ok 260
ok 261
ok 262
ok 263
ok 264
ok 265
ok 266
ok 267
ok 268
ok 269
ok 270
ok 271
ok 272
ok 273
ok 274
ok 275
ok 276
ok 277
ok 278
ok 279
long_data0 length 20480
long_data1 length 81920
long_data2 length 71680
create table dbd_ora__drop_me ( idx integer, lng LONG RAW, dt date )
--- insert some LONG RAW data (ora_type 24)
ok 280
ok 281
ok 282
ok 283
ok 284
--- fetch LONG RAW data back again -- truncated - LongTruncOk == 1
LongReadLen 20, LongTruncOk 1
ok 285
ok 286
ok 287
ok 288
ok 289
ok 290
ok 291
ok 292
--- fetch LONG RAW data back again -- truncated - LongTruncOk == 0
LongReadLen 40955, LongTruncOk
ok 293
ok 294
ok 295
ok 296
ok 297
ok 298
--- fetch LONG RAW data back again -- complete - LongTruncOk == 0
LongReadLen 82920, LongTruncOk
ok 299
ok 300
ok 301
ok 302
ok 303
ok 304
ok 305
ok 306
--- fetch LONG RAW data back again -- via blob_read
Skipped blob_read tests for LONGs with OCI8 - not currently supported.
ok 307
ok 308
ok 309
ok 310
ok 311
ok 312
ok 313
ok 314
ok 315
ok 316
ok 317
ok 318
ok 319
ok 320
ok 321
ok 322
ok 323
ok 324
ok 325
ok 326
ok 327
ok 328
ok 329
ok 330
ok 331
ok 332
ok 333
ok 334
ok 335
ok 336
ok 337
ok 338
ok 339
ok 340
ok 341
ok 342
ok 343
ok 344
ok 345
ok 346
ok 347
ok 348
ok 349
ok 350
ok 351
ok 352
ok 353
ok 354
Some tests for LONG data type handling failed. These are generally Oracle bugs.
ok 355
ok 356
ok 357
ok 358
ok 359
ok 360
ok 361
ok 362
Please report this to the dbi-users mailing list, and include the
Oracle version number of both the client and the server.
Please also include the output of the 'perl -V' command.
(If you can, please study t/long.t to investigate the cause.
Feel free to edit the tests to see what's happening in more detail.
Especially by adding trace() calls around the failing tests.
Run the tests manually using the command "perl -Mblib t/long.t")
Meanwhile, if the other tests have passed you can use DBD::Oracle.
ok 363
ok 364
ok 365
ok 366
ok 367
ok 368
ok 369
ok 370
ok 371
ok 372
dubious
Test returned status 4 (wstat 1024, 0x400)
DIED. FAILED tests 60, 68, 76, 86, 88, 90, 153, 161, 169, 179, 181, 183
Failed 12/372 tests, 96.77% okay
Failed Test Stat Wstat Total Fail Failed List of Failed
-------------------------------------------------------------------------------
t\long.t 4 1024 372 12 3.23% 60 68 76 86 88 90 153 161 169 179
181 183
Failed 1/1 test scripts, 0.00% okay. 12/372 subtests failed, 96.77% okay.
