RE: DBD::Oracle-1.26 fails test t/31lob.t on Oracle 11gR2 Ubuntu 10.04

I'm not sure exactly how to run the "prove" command.  When I try it as
"prove t/31lob.t" it gives:

Can't locate DBD/Oracle.pm in @INC (@INC contains: /etc/perl
/usr/local/lib/per.
BEGIN failed--compilation aborted at t/31lob.t line 5.
# Looks like your test exited with 2 before it could output anything.
t/31lob.t .. 
Dubious, test returned 2 (wstat 512, 0x200)
Failed 12/12 subtests 

Test Summary Report
-------------------
t/31lob.t (Wstat: 512 Tests: 0 Failed: 0)
  Non-zero exit status: 2
  Parse errors: Bad plan.  You planned 12 tests but ran 0.
Files=1, Tests=0,  0 wallclock secs ( 0.06 usr  0.01 sys +  0.04 cusr
0.01 csy)
Result: FAIL

I assume I'm not running this correctly.  It appears to be looking for
an installed version of DBD which I haven't done at the point.  I just
attempting to install DBD and haven't actually done the "make install".

Instead I ran the "make test TEST_VERBOSE=1", not all results shown,
just for t/31lob.t.  Hope this will shed some light.
 
. . . .
ok 479
ok
? ); END;" with ParamValues: :p1=undef,
:p2=OCILobLocatorPtr=SCALAR(0x1e8a0d8)].

#   Failed test 'returned length via PL/SQL'
#   at t/31lob.t line 143.
#          got: undef
#     expected: '40000'
t/31lob.t ............... 
1..12
ok 1 - returned valid locator
ok 2 - inserted into BLOB successfully
ok 3 - got back what we put in
ok 4 - returned valid locator
ok 5 - returned valid locator
ok 6 - returned initialized locator
ok 7 - returned length
ok 8 - returned written value
not ok 9 - returned length via PL/SQL
Errors in file :
OCI-21500: internal error code, arguments: [kghufree_06], [0x001C2A838],
[0], []
????????????????Errors in file :
OCI-21500: internal error code, arguments: [kghufree_06], [0x001C2A838],
[0], []
????????????????????????????????
Dubious, test returned 1 (wstat 256, 0x100)
Failed 4/12 subtests 
# create table dbd_ora__drop_me ( idx integer, x clob,  dt date )
# procedure p_DBD_Oracle_drop_me dropped
# table dbd_ora__drop_me dropped
t/31lob_extended.t ...... 
1..31
. . . .

-----Original Message-----
From: John Scoles [mailto:[email protected]] 
Sent: Tuesday, October 19, 2010 12:03 PM
To: CAMPBELL, ED (ATTBST)
Cc: [email protected]
Subject: Re: DBD::Oracle-1.26 fails test t/31lob.t on Oracle 11gR2
Ubuntu 10.04


  On 10/19/2010 10:34 AM, CAMPBELL, ED (ATTBST) wrote:

No I do not think you buggered anything up.

Might be a permissions error or alike or a change in Oracle 11gR2 sounds

very new.

if you can do a

  prove (t/31lob.t)  on it so we can get the deatils of that test that 
will help narrow it down

cheers
John Scoles
> When I do make test on DBD::Oracle-1.26 with Oracle 11gR2 on Ubuntu
> 10:04 x64 it fails t/31lob.t test 9.  Is this a known problem or am I
> doing something wrong.
>
> My perl info:
> $ perl -V
> Summary of my perl5 (revision 5 version 10 subversion 1)
configuration:
>
>    Platform:
>      osname=linux, osvers=2.6.24-27-server,
> archname=x86_64-linux-gnu-thread-muli
>      uname='linux crested 2.6.24-27-server #1 smp fri mar 12 01:23:09
utc
> 2010 x'
>      config_args='-Dusethreads -Duselargefiles -Dccflags=-DDEBIAN
> -Dcccdlflags=-'
>      hint=recommended, useposix=true, d_sigaction=define
>      useithreads=define, usemultiplicity=define
>      useperlio=define, d_sfio=undef, uselargefiles=define,
usesocks=undef
>      use64bitint=define, use64bitall=define, uselongdouble=undef
>      usemymalloc=n, bincompat5005=undef
>    Compiler:
>      cc='cc', ccflags ='-D_REENTRANT -D_GNU_SOURCE -DDEBIAN
> -fno-strict-aliasing,
>      optimize='-O2 -g',
>      cppflags='-D_REENTRANT -D_GNU_SOURCE -DDEBIAN
-fno-strict-aliasing
> -pipe -f'
>      ccversion='', gccversion='4.4.3', gccosandvers=''
>      intsize=4, longsize=8, ptrsize=8, doublesize=8,
byteorder=12345678
>      d_longlong=define, longlongsize=8, d_longdbl=define,
longdblsize=16
>      ivtype='long', ivsize=8, nvtype='double', nvsize=8,
Off_t='off_t',
> lseeksiz8
>      alignbytes=8, prototype=define
>    Linker and Libraries:
>      ld='cc', ldflags =' -fstack-protector -L/usr/local/lib'
>      libpth=/usr/local/lib /lib /usr/lib /lib64 /usr/lib64
>      libs=-lgdbm -lgdbm_compat -ldb -ldl -lm -lpthread -lc -lcrypt
>      perllibs=-ldl -lm -lpthread -lc -lcrypt
>      libc=/lib/libc-2.11.1.so, so=so, useshrplib=true,
> libperl=libperl.so.5.10.1
>      gnulibc_version='2.11.1'
>    Dynamic Linking:
>      dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Wl,-E'
>      cccdlflags='-fPIC', lddlflags='-shared -O2 -g -L/usr/local/lib
> -fstack-prot'
>
>
> Characteristics of this binary (from libperl):
>    Compile-time options: MULTIPLICITY PERL_DONT_CREATE_GVSV
>                          PERL_IMPLICIT_CONTEXT PERL_MALLOC_WRAP
> USE_64_BIT_ALL
>                          USE_64_BIT_INT USE_ITHREADS USE_LARGE_FILES
>                          USE_PERLIO USE_REENTRANT_API
>    Built under linux
>    Compiled at Apr 23 2010 08:21:31
>    @INC:
>      /etc/perl
>      /usr/local/lib/perl/5.10.1
>      /usr/local/share/perl/5.10.1
>      /usr/lib/perl5
>      /usr/share/perl5
>      /usr/lib/perl/5.10
>      /usr/share/perl/5.10
>      /usr/local/lib/site_perl
>      .
>
> My DBI info:
> perl -MDBI -e 'print "$DBI::VERSION\n"'
> 1.609
>
> The output of the 'make test':
> PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e"
> "test_harness(0,t
> # Test loading DBI, DBD::Oracle and version
> t/01base.t .............. ok
> t/10general.t ........... ok
> t/12impdata.t ........... ok
> t/14threads.t ........... ok
> t/15nls.t ............... ok
> t/20select.t ............ ok
> t/21nchar.t ............. ok
> t/22nchar_al32utf8.t .... ok
> t/22nchar_utf8.t ........ ok
> t/23wide_db.t ........... skipped: Database character set is not
Unicode
> t/23wide_db_8bit.t ...... skipped: Database character set is not
Unicode
> t/23wide_db_al32utf8.t .. skipped: Database character set is not
Unicode
> t/24implicit_utf8.t ..... ok
> t/25plsql.t ............. ok
> t/26exe_array.t ......... ok
> t/28array_bind.t ........ ok
> t/30long.t .............. ok
> t t/31lob.t line 126.
> :
>
> t/31lob.t ...............
> Dubious, test returned 1 (wstat 256, 0x100)
> Failed 4/12 subtests
> t/31lob_extended.t ...... ok
> t/32xmltype.t ........... ok
> t/34pres_lobs.t ......... ok
>   Placeholder behaviour for ora_type=1 VARCHAR2 (the default) varies
with
> Oracle.
>   Oracle 7 didn't strip trailing spaces, Oracle 8 did, until 9.2.x
>   Your system doesn't. If that seems odd, let us know.
> t/40ph_type.t ........... ok
> Can't determine open_cursors from v$parameter, so using default
> t/50cursor.t ............ ok
> t/51scroll.t ............ ok
> t/55nested.t ............ ok
> t/56embbeded.t .......... ok
> t/58object.t ............ ok
> t/60reauth.t ............ skipped: ORACLE_USERID_2 not unique.
> t/70meta.t .............. ok
> t/80ora_charset.t ....... ok
>
>
> Test Summary Report
> -------------------
> t/31lob.t             (Wstat: 256 Tests: 9 Failed: 1)
>    Failed test:  9
>    Non-zero exit status: 1
>    Parse errors: Bad plan.  You planned 12 tests but ran 9.
> Files=30, Tests=1166, 26 wallclock secs ( 0.46 usr  0.15 sys + 11.99
> cusr  1.72)
> Result: FAIL
> Failed 1/30 test programs. 1/1166 subtests failed.
> make: *** [test_dynamic] Error 255
> ec0631@atl-mad08-glr:~/DBD-Oracle-1.26
>
> $ perl -V
> Summary of my perl5 (revision 5 version 10 subversion 1)
configuration:
>
>    Platform:
>      osname=linux, osvers=2.6.24-27-server,
> archname=x86_64-linux-gnu-thread-muli
>      uname='linux crested 2.6.24-27-server #1 smp fri mar 12 01:23:09
utc
> 2010 x'
>      config_args='-Dusethreads -Duselargefiles -Dccflags=-DDEBIAN
> -Dcccdlflags=-'
>      hint=recommended, useposix=true, d_sigaction=define
>      useithreads=define, usemultiplicity=define
>      useperlio=define, d_sfio=undef, uselargefiles=define,
usesocks=undef
>      use64bitint=define, use64bitall=define, uselongdouble=undef
>      usemymalloc=n, bincompat5005=undef
>    Compiler:
>      cc='cc', ccflags ='-D_REENTRANT -D_GNU_SOURCE -DDEBIAN
> -fno-strict-aliasing,
>      optimize='-O2 -g',
>      cppflags='-D_REENTRANT -D_GNU_SOURCE -DDEBIAN
-fno-strict-aliasing
> -pipe -f'
>      ccversion='', gccversion='4.4.3', gccosandvers=''
>      intsize=4, longsize=8, ptrsize=8, doublesize=8,
byteorder=12345678
>      d_longlong=define, longlongsize=8, d_longdbl=define,
longdblsize=16
>      ivtype='long', ivsize=8, nvtype='double', nvsize=8,
Off_t='off_t',
> lseeksiz8
>      alignbytes=8, prototype=define
>    Linker and Libraries:
>      ld='cc', ldflags =' -fstack-protector -L/usr/local/lib'
>      libpth=/usr/local/lib /lib /usr/lib /lib64 /usr/lib64
>      libs=-lgdbm -lgdbm_compat -ldb -ldl -lm -lpthread -lc -lcrypt
>      perllibs=-ldl -lm -lpthread -lc -lcrypt
>      libc=/lib/libc-2.11.1.so, so=so, useshrplib=true,
> libperl=libperl.so.5.10.1
>      gnulibc_version='2.11.1'
>    Dynamic Linking:
>      dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Wl,-E'
>      cccdlflags='-fPIC', lddlflags='-shared -O2 -g -L/usr/local/lib
> -fstack-prot'
>
>
> Characteristics of this binary (from libperl):
>    Compile-time options: MULTIPLICITY PERL_DONT_CREATE_GVSV
>                          PERL_IMPLICIT_CONTEXT PERL_MALLOC_WRAP
> USE_64_BIT_ALL
>                          USE_64_BIT_INT USE_ITHREADS USE_LARGE_FILES
>                          USE_PERLIO USE_REENTRANT_API
>    Built under linux
>    Compiled at Apr 23 2010 08:21:31
>    @INC:
>      /etc/perl
>      /usr/local/lib/perl/5.10.1
>      /usr/local/share/perl/5.10.1
>      /usr/lib/perl5
>      /usr/share/perl5
>      /usr/lib/perl/5.10
>      /usr/share/perl/5.10
>      /usr/local/lib/site_perl
>      .
> ec0631@atl-mad08-glr:~/DBD-Oracle-1.26
> $ perl -MDBI -e 'print "$DBI::VERSION\n"'
> 1.609
> ec0631@atl-mad08-glr:~/DBD-Oracle-1.26
> $ cat test.out
> PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e"
> "test_harness(0,t
> # Test loading DBI, DBD::Oracle and version
> t/01base.t .............. ok
> t/10general.t ........... ok
> t/12impdata.t ........... ok
> t/14threads.t ........... ok
> t/15nls.t ............... ok
> t/20select.t ............ ok
> t/21nchar.t ............. ok
> t/22nchar_al32utf8.t .... ok
> t/22nchar_utf8.t ........ ok
> t/23wide_db.t ........... skipped: Database character set is not
Unicode
> t/23wide_db_8bit.t ...... skipped: Database character set is not
Unicode
> t/23wide_db_al32utf8.t .. skipped: Database character set is not
Unicode
> t/24implicit_utf8.t ..... ok
> t/25plsql.t ............. ok
> t/26exe_array.t ......... ok
> t/28array_bind.t ........ ok
> t/30long.t .............. ok
> DBD::Oracle::st execute failed: ORA-24813: cannot send or receive an
> unsupporte.
>
> t/31lob.t ...............
> Dubious, test returned 1 (wstat 256, 0x100)
> Failed 4/12 subtests
> t/31lob_extended.t ...... ok
> t/32xmltype.t ........... ok
> t/34pres_lobs.t ......... ok
>   Placeholder behaviour for ora_type=1 VARCHAR2 (the default) varies
with
> Oracle.
>   Oracle 7 didn't strip trailing spaces, Oracle 8 did, until 9.2.x
>   Your system doesn't. If that seems odd, let us know.
> t/40ph_type.t ........... ok
> Can't determine open_cursors from v$parameter, so using default
> t/50cursor.t ............ ok
> t/51scroll.t ............ ok
> t/55nested.t ............ ok
> t/56embbeded.t .......... ok
> t/58object.t ............ ok
> t/60reauth.t ............ skipped: ORACLE_USERID_2 not unique.
> t/70meta.t .............. ok
> t/80ora_charset.t ....... ok
>
> Test Summary Report
> -------------------
> t/31lob.t             (Wstat: 256 Tests: 9 Failed: 1)
>    Failed test:  9
>    Non-zero exit status: 1
>    Parse errors: Bad plan.  You planned 12 tests but ran 9.
> Files=30, Tests=1166, 26 wallclock secs ( 0.46 usr  0.15 sys + 11.99
> cusr  1.72)
> Result: FAIL
> Failed 1/30 test programs. 1/1166 subtests failed.
> make: *** [test_dynamic] Error 255
> ec0631@atl-mad08-glr:~/DBD-Oracle-1.26
> $
>
>
> I will appreciate any help or information about this error.
>
> Thanks
>