Hello All,
I need your help, now I am trying to use DBD::Oracle on Oracle 11g on Solaris
10.
I am blocked with two test files: t/31lob.t and t/58object.t:
1)There are some garbled characters when I executed the 31lob.t alone.
2)When I executed the 58object.t alone, it quits without any error msg.
~/DBD-Oracle-1.27$make test
PERL_DL_NONLAZY=1 /home/tester/perl/bin/perl "-MExtUtils::Command::MM"
"-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/01base.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 ........... ok
t/23wide_db_8bit.t ...... ok
t/23wide_db_al32utf8.t .. ok
t/24implicit_utf8.t ..... ok
t/25plsql.t ............. ok
t/26exe_array.t ......... ok
t/28array_bind.t ........ ok
t/30long.t .............. ok
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
t/40ph_type.t ........... 1/19 Placeholder behaviour for ora_type=1
VARCHAR2 (the default) varies with Oracle version.
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
t/50cursor.t ............ ok
t/51scroll.t ............ ok
t/55nested.t ............ ok
t/56embbeded.t .......... ok
t/58object.t ............ Dubious, test returned 1 (wstat 256, 0x100)
Failed 28/51 subtests
t/60reauth.t ............ skipped: ORACLE_USERID_2 not defined.
t/70meta.t .............. ok
t/80ora_charset.t ....... ok
Test Summary Report
-------------------
t/31lob.t (Wstat: 256 Tests: 8 Failed: 0)
Non-zero exit status: 1
Parse errors: Bad plan. You planned 12 tests but ran 8.
t/58object.t (Wstat: 256 Tests: 23 Failed: 0)
Non-zero exit status: 1
Parse errors: Bad plan. You planned 51 tests but ran 23.
Files=30, Tests=2254, 85 wallclock secs ( 2.34 usr 0.72 sys + 44.29
cusr 4.22 csys = 51.57 CPU)
Result: FAIL
Failed 2/30 test programs. 0/2254 subtests failed.
*** Error code 255
make: Fatal error: Command failed for target `test_dynamic'
~/DBD-Oracle-1.27$perl -Mlib=./lib,./blib/lib,./blib/arch 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
Errors in file :
OCI-21500: internal error code, arguments: [kpullas-1], [], [], [], [],
[], [], []
ÿÿÿÿ}ãØ¿ÿÿÿÿyÍßÿÿÿÿsl`ÿÿÿÿ}ãØ¿ÿÿÿÿyÍßÿÿÿÿsl`ÿÿÿÿ}ãØ¿ÿÿÿÿyÍßÿÿÿÿsl`ÿÿÿÿ}ãØ¿ÿÿÿÿyÍßÿÿÿÿsl`ÿÿÿÿ}ãØ¿ÿÿÿÿyÍßÿÿÿÿsl`ÿÿÿÿ}ãØ¿ÿÿÿÿyÍßÿÿÿÿsl`Errors
in file :
OCI-21500: internal error code, arguments: [kpullas-1], [], [], [], [],
[], [], []
ÿÿÿÿ}ãØ¿ÿÿÿÿyÍßÿÿÿÿsl`ÿÿÿÿ}ãØ¿ÿÿÿÿyÍßÿÿÿÿsl`ÿÿÿÿ}ãØ¿ÿÿÿÿyÍßÿÿÿÿsl`ÿÿÿÿ}ãØ¿ÿÿÿÿyÍßÿÿÿÿsl`ÿÿÿÿ}ãØ¿ÿÿÿÿyÍßÿÿÿÿsl`ÿÿÿÿ}ãØ¿ÿÿÿÿyÍßÿÿÿÿsl`~/DBD-Oracle-1.27$
~/DBD-Oracle-1.27$perl -Mlib=./lib,./blib/lib,./blib/arch t/58object.t
1..51
ok 1 - use DBI;
ok 2 - ora_objects flag is set to 1
ok 3 - ora_objects flag is set to 0
ok 4 - The object isa DBI::db
ok 5 - Fetch current schema name
ok 6 - old: Prepare select
ok 7 - old: Execute select
ok 8 - old: Fetch first row
ok 9 - old: Row 1 column 2 is an ARRAY
ok 10 - old: Row 1 column 2 is has 2 elements
ok 11 - old: Fetch second row
ok 12 - old: Row 2 column 2 is an ARRAY
ok 13 - old: Row 2 column 2 is has 2 elements
ok 14 - old: Fetch third row
ok 15 - old: Row 3 column 2 is an ARRAY
ok 16 - old: Row 3 column 2 is has 2 elements
ok 17 - old: No more rows expected
ok 18 - new: Prepare select
ok 19 - new: Execute select
ok 20 - new: Fetch first row
ok 21 - new: Row 1 column 2 is an DBD:Oracle::Object
ok 22 - new: Row 1 column 2 object type
ok 23 - new: Row 1 column 2 object attributes
~/DBD-Oracle-1.27$
perl -V
Summary of my perl5 (revision 5 version 12 subversion 2) configuration:
Platform:
osname=solaris, osvers=2.10, archname=sun4-solaris-thread-multi-64
uname='sunos lteoam181 5.10 generic_141444-09 sun4v sparc
sunw,sparc-enterprise-t5220 '
config_args='-des -Dprefix=/home/tester/perl -Duse64bitall
-Dusethreads -Duseithreads'
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 -xarch=generic64
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -DPERL_USE_SAFE_PUTENV',
optimize='-O',
cppflags='-D_REENTRANT -xarch=generic64'
ccversion='Sun C 5.11 SunOS_sparc 2010/08/13', gccversion='',
gccosandvers=''
intsize=4, longsize=8, ptrsize=8, doublesize=8, byteorder=87654321
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
ivtype='long', ivsize=8, nvtype='double', nvsize=8, Off_t='off_t',
lseeksize=8
alignbytes=8, prototype=define
Linker and Libraries:
ld='cc', ldflags =' -xarch=generic64
-L/opt/solstudio12.2/prod/lib/sparc/64 -L/opt/solstudio12.2/prod/lib/v9
-L/lib/64 -L/usr/lib/sparcv9 -L/usr/ccs/lib/sparcv9 '
libpth=/opt/solstudio12.2/prod/lib/sparc/64
/opt/solstudio12.2/prod/lib/v9 /lib/64 /usr/lib/sparcv9 /usr/ccs/lib/sparcv9
/usr/lib /usr/ccs/lib
libs=-lsocket -lnsl -ldl -lm -lpthread -lc
perllibs=-lsocket -lnsl -ldl -lm -lpthread -lc
libc=/usr/lib/sparcv9/libc.so, so=so, useshrplib=false,
libperl=libperl.a
gnulibc_version=''
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags=' '
cccdlflags='-KPIC', lddlflags=' -G -xarch=generic64
-L/opt/solstudio12.2/prod/lib/sparc/64 -L/opt/solstudio12.2/prod/lib/v9
-L/lib/64 -L/usr/lib/sparcv9 -L/usr/ccs/lib/sparcv9'
Characteristics of this binary (from libperl):
Compile-time options: MULTIPLICITY PERL_DONT_CREATE_GVSV
PERL_IMPLICIT_CONTEXT PERL_MALLOC_WRAP
PERL_USE_SAFE_PUTENV USE_64_BIT_ALL
USE_64_BIT_INT
USE_ITHREADS USE_LARGE_FILES USE_PERLIO
USE_PERL_ATOF
USE_REENTRANT_API
Built under solaris
Compiled at Dec 24 2010 12:46:07
@INC:
/home/tester/perl/lib/site_perl/5.12.2/sun4-solaris-thread-multi-64
/home/tester/perl/lib/site_perl/5.12.2
/home/tester/perl/lib/5.12.2/sun4-solaris-thread-multi-64
/home/tester/perl/lib/5.12.2
.
