develooper Front page | perl.dbi.users | Postings from January 2011

make test failed with DBD::Oracle 1.27

Thread Next
From:
ZHANG Jiaqiang A
Date:
January 5, 2011 01:31
Subject:
make test failed with DBD::Oracle 1.27
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
	    .
	 
	 




Thread Next


nntp.perl.org: Perl Programming lists via nntp and http.
Comments to Ask Bjørn Hansen at ask@perl.org | Group listing | About