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