make test failed with DBD::Oracle 1.27

[email protected] ("ZHANG Jiaqiang A")
Newsgroups perl.dbi.users
Message-ID <2A2A58A93CD9374C9C53DCB8629BBAAE0585E2EC@CNSHGSMBS01.ad4.ad.alcatel.com>
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
	    .
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.