Setting LongReadLen to 64000 had no effect - exact same problem. I am
running DBD::Oracle 1.13, and here's the result of the test:
pink:/home/miller/.cpan/build/DBD-Oracle-1.13> setenv ORACLE_USERID
scott/[EMAIL PROTECTED]
pink:/home/miller/.cpan/build/DBD-Oracle-1.13> make test
PERL_DL_NONLAZY=1
/home/miller/bin/perl -Iblib/arch -Iblib/lib -I/home/miller/lib/perl5/5.6.1/
i586-linux -I/home/miller/lib/perl5/5.6.1 -e 'use Test::Harness qw(&runtests
$verbose); $verbose=0; runtests @ARGV;' t/*.t
t/base.......ok
t/cursor.....ok
t/general....ok
t/long.......ok 8/151# failed test 9 at line 175.
t/long.......ok 10/151Use of uninitialized value in string eq at t/long.t
line 178.
Use of uninitialized value in length at t/long.t line 178.
Use of uninitialized value in length at t/long.t line 373.
Use of uninitialized value in string eq at t/long.t line 374.
# failed test 11 at line 178. Strings are of different lengths (0 vs 20),
Len 0
t/long.......NOK 11Use of uninitialized value in string eq at t/long.t line
180.
Use of uninitialized value in length at t/long.t line 180.
Use of uninitialized value in length at t/long.t line 373.
Use of uninitialized value in string eq at t/long.t line 374.
# failed test 12 at line 180. Strings are of different lengths (0 vs 20),
Len 0
t/long.......ok 17/151# failed test 18 at line 203. ORA-01801: date format
is too long for internal buffer (DBD ERROR: OCIStmtFetch)
t/long.......ok 151/151
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.......FAILED tests 9, 11-12, 18
Failed 4/151 tests, 97.35% okay
t/ph_type....ok
t/plsql......ok
t/select.....ok
Failed Test Stat Wstat Total Fail Failed List of Failed
----------------------------------------------------------------------------
---
t/long.t 151 4 2.65% 9 11-12 18
Failed 1/8 test scripts, 75.00% okay. 4/300 subtests failed, 98.67% okay.
make: *** [test_dynamic] Error 11
pink:/home/miller/.cpan/build/DBD-Oracle-1.13>
----------------------------------------------------------------------------
-------------------------
Uh oh. Shame on me. I missed these results before because ORACLE_USERID
wasn't set correctly.
Now, I ran make test again, and it ran successfully a few times. Then, I
ran it again, and I got this:
pink:/home/miller/.cpan/build/DBD-Oracle-1.13> make test
PERL_DL_NONLAZY=1
/home/miller/bin/perl -Iblib/arch -Iblib/lib -I/home/miller/lib/perl5/5.6.1/
i586-linux -I/home/miller/lib/perl5/5.6.1 -e 'use Test::Harness qw(&runtests
$verbose); $verbose=0; runtests @ARGV;' t/*.t
t/base.......ok
t/cursor.....ok
t/general....ok
t/long.......ok 8/151# failed test 9 at line 175.
t/long.......ok 11/151Use of uninitialized value in string eq at t/long.t
line 180.
Use of uninitialized value in length at t/long.t line 180.
Use of uninitialized value in length at t/long.t line 373.
Use of uninitialized value in string eq at t/long.t line 374.
# failed test 12 at line 180. Strings are of different lengths (0 vs 20),
Len 0
t/long.......ok 151/151
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.......FAILED tests 9, 12
Failed 2/151 tests, 98.68% okay
t/ph_type....ok
t/plsql......ok
t/select.....ok
Failed Test Stat Wstat Total Fail Failed List of Failed
----------------------------------------------------------------------------
---
t/long.t 151 2 1.32% 9 12
Failed 1/8 test scripts, 75.00% okay. 2/300 subtests failed, 99.33% okay.
make: *** [test_dynamic] Error 11
pink:/home/miller/.cpan/build/DBD-Oracle-1.13>
#######################
Different tests failed. Non-deterministic. Gotta love that.
Here's the rest of the information:
pink:/home/miller/.cpan/build/DBD-Oracle-1.13/t> perl -V
Summary of my perl5 (revision 5.0 version 6 subversion 1) configuration:
Platform:
osname=linux, osvers=2.2.19, archname=i586-linux
uname='linux pink 2.2.19 #1 sun apr 8 13:42:11 est 2001 i586 unknown '
config_args='-Doptimize=-g'
hint=recommended, useposix=true, d_sigaction=define
usethreads=undef use5005threads=undef useithreads=undef
usemultiplicity=undef
useperlio=undef d_sfio=undef uselargefiles=define usesocks=undef
use64bitint=undef use64bitall=undef uselongdouble=undef
Compiler:
cc='cc', ccflags
='-DDEBUGGING -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64',
optimize='-g',
cppflags='-DDEBUGGING -fno-strict-aliasing -I/usr/local/include'
ccversion='', gccversion='2.95.2 20000220 (Debian GNU/Linux)',
gccosandvers=''
intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12
ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t',
lseeksize=8
alignbytes=4, usemymalloc=n, prototype=define
Linker and Libraries:
ld='cc', ldflags =' -L/usr/local/lib'
libpth=/usr/local/lib /lib /usr/lib
libs=-lnsl -lndbm -lgdbm -ldb -ldl -lm -lc -lposix -lcrypt -lutil
perllibs=-lnsl -ldl -lm -lc -lposix -lcrypt -lutil
libc=/lib/libc-2.1.3.so, so=so, useshrplib=false, libperl=libperl.a
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-rdynamic'
cccdlflags='-fpic', lddlflags='-shared -L/usr/local/lib'
Characteristics of this binary (from libperl):
Compile-time options: DEBUGGING USE_LARGE_FILES
Built under linux
Compiled at Feb 28 2002 09:11:39
%ENV:
PERL5LIB="/home/miller/src/perl:/home/miller/src/husky/cardlock/lib:/home/mi
ller/src/husky/cardlock/web/sub"
@INC:
/home/miller/src/perl
/home/miller/src/husky/cardlock/lib
/home/miller/src/husky/cardlock/web/sub
/home/miller/lib/perl5/5.6.1/i586-linux
/home/miller/lib/perl5/5.6.1
/home/miller/lib/perl5/site_perl/5.6.1/i586-linux
/home/miller/lib/perl5/site_perl/5.6.1
/home/miller/lib/perl5/site_perl
.
Oracle versions: 8.1.7 on both client and server sides.
Hmmm. I'm wondering if something is botched on my Debian system, like a bad
shared lib or something similar. I've been meaning to rebuild my system for
quite a while; perhaps this is the opportunity. That is, unless you have
some other suggestions? I'll try installing 1.14rc1 and see what happens;
more of the same, I suspect.
Cheers!
-klm.
