Thanks, I've been fortunate enough in my dealings with DBD or DBI that I haven't had to run prove at this point..
The output from "prove -vb t/31lob.t" follows: DBD::Oracle::st execute failed: ORA-24813: cannot send or receive an unsupporte. # 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], [0x0023CBDC8], [0], [] )Or?)Or?Errors in file : OCI-21500: internal error code, arguments: [kghufree_06], [0x0023CBDC8], [0], [] ----???????????????? Dubious, test returned 1 (wstat 256, 0x100) Failed 4/12 subtests 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=1, Tests=9, 0 wallclock secs ( 0.05 usr 0.01 sys + 0.23 cusr 0.06 csy) Result: FAIL It appears to be the same as output from "make test TEST_VERBOSE=1". -----Original Message----- From: Martin J. Evans [mailto:martin.ev...@easysoft.com] Sent: Tuesday, October 19, 2010 2:23 PM To: dbi-users@perl.org Subject: Re: DBD::Oracle-1.26 fails test t/31lob.t on Oracle 11gR2 Ubuntu 10.04 On 19/10/2010 18:17, CAMPBELL, ED (ATTBST) wrote: > 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 > You need prove -vb t/32lob.t if you run it from the untarred DBD::Oracle distribution else you are attempting to run it using the installed DBD::Oracle which clearly you do not have. I think it adds -Iblib/lib and -Iblib/arch to the Perl command line. I think unrelated but "/usr/local/lib/per" in INC looks strange. Martin > 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 >>
