The output told me to report this to the list, so here I am...
Oracle 8.1.7.2
perl -V:
Characteristics of this binary (from libperl):
Built under solaris
Compiled at Apr 3 1999 00:26:08
@INC:
/usr/local/lib/perl5/5.00503/sun4-solaris
/usr/local/lib/perl5/5.00503
/usr/local/lib/perl5/site_perl/5.005/sun4-solaris
/usr/local/lib/perl5/site_perl/5.005
.
Here's the output of test:
t/long..............Use of uninitialized value at t/long.t line 230.
# failed test 98 at line 230. ORA-01403: no data found (DBD NEED_DATA: OCILobRead)
Use of uninitialized value at t/long.t line 231.
Use of uninitialized value at t/long.t line 345.
Use of uninitialized value at t/long.t line 346.
# failed test 99 at line 231. Strings are of different lengths (0 vs 10240)
# failed test 100 at line 233. ORA-03118: two-task coroutine has invalid state (DBD
ERROR: OCIStmtFetch)
Use of uninitialized value at t/long.t line 234.
# failed test 101 at line 234. ORA-03106: fatal two-task communication protocol error
(DBD ERROR: OCILobGetLength)
Use of uninitialized value at t/long.t line 235.
Use of uninitialized value at t/long.t line 345.
Use of uninitialized value at t/long.t line 346.
# failed test 102 at line 235. Strings are of different lengths (0 vs 81920)
# failed test 103 at line 237. ERROR no statement executing (perhaps you need to call
execute first)
Use of uninitialized value at t/long.t line 240.
Use of uninitialized value at t/long.t line 245.
Use of uninitialized value at t/long.t line 262.
# failed test 104 at line 262. Fetched length , expected 71680
# failed test 105 at line 263.
Unable to create test table for 'BLOB' data (3127). Tests skipped.
# failed test 141 at line 86. lob_locator false
# failed test 142 at line 87.
# failed test 143 at line 88. lob_locator deref ptr false
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.
FAILED tests 98-105, 141-143
Failed 11/143 tests, 92.31% okay
t/ph_type...........ok
t/plsql.............ok
t/reauth............skipping test on this platform
Failed Test Status Wstat Total Fail Failed List of failed
-------------------------------------------------------------------------------
t/long.t 143 11 7.69% 98-105, 141-143
1 test skipped.
Failed 1/6 test scripts, 83.33% okay. 11/281 subtests failed, 96.09% okay.
make: *** [test_dynamic] Error 29
# perl -V
Summary of my perl5 (5.0 patchlevel 5 subversion 3) configuration:
Platform:
osname=solaris, osvers=2.6, archname=sun4-solaris
uname='sunos 5.6 generic_105181-06 sun4u sparc sunw,ultra-1 '
hint=recommended, useposix=true, d_sigaction=define
usethreads=undef useperlio=undef d_sfio=undef
Compiler:
cc='gcc', optimize='-O', gccversion=2.8.1
cppflags='-I/usr/local/include'
ccflags ='-I/usr/local/include'
stdchar='unsigned char', d_stdstdio=define, usevfork=false
intsize=4, longsize=4, ptrsize=4, doublesize=8
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
alignbytes=8, usemymalloc=y, prototype=define
Linker and Libraries:
ld='gcc', ldflags =' -L/usr/local/lib'
libpth=/usr/local/lib /lib /usr/lib /usr/ccs/lib
libs=-lsocket -lnsl -ldb -ldl -lm -lc -lcrypt
libc=/lib/libc.so, so=so, useshrplib=false, libperl=libperl.a
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags=' '
cccdlflags='-fPIC', lddlflags='-G -L/usr/local/lib'
--
