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:sco...@pythian.com] Sent: Tuesday, October 19, 2010 12:03 PM To: CAMPBELL, ED (ATTBST) Cc: dbi-users@perl.org 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 > ec0...@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 > . > ec0...@atl-mad08-glr:~/DBD-Oracle-1.26 > $ perl -MDBI -e 'print "$DBI::VERSION\n"' > 1.609 > ec0...@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 > ec0...@atl-mad08-glr:~/DBD-Oracle-1.26 > $ > > > I will appreciate any help or information about this error. > > Thanks >