Hello again,
I am still not having any luck in getting the tests to pass. It appears to
be the CLOB re-reading that is failing.
I have checked all the usual places for help. I have also tried creating a
test stub that does a similar thing to the failed tests.
Below is the full set of information from the build and test as requested
(note this is long).
Anyone any ideas?
Ben.
> perl Makefile.PL -v
Using DBI 1.32 installed in
/usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris/auto/DBI
Duplicate specification "S=s" for option "s"
Configuring DBD::Oracle ...
>>> Remember to actually *READ* the README file!
Especially if you have any problems.
Using Oracle in /usr/local/oracle/product/9.2.0
Found rdbms/demo/oratypes.h
Found rdbms/demo/ocixad.h
Found rdbms/demo/oci8dp.h
Found rdbms/demo/ociapr.h
Found rdbms/demo/ocidef.h
Found rdbms/demo/ocidem.h
Found rdbms/demo/ocidfn.h
Found rdbms/demo/ocikpr.h
Found header files in rdbms/demo.
Found /usr/local/oracle/product/9.2.0/rdbms/demo/demo_rdbms.mk
Found /usr/local/oracle/product/9.2.0/otrace/demo/atmoci.mk
Found /usr/local/oracle/product/9.2.0/precomp/demo/proc/demo_proc.mk
Using /usr/local/oracle/product/9.2.0/rdbms/demo/demo_rdbms.mk
Reading /usr/local/oracle/product/9.2.0/rdbms/demo/demo_rdbms.mk.
Reading /usr/local/oracle/product/9.2.0/rdbms/lib/env_rdbms.mk.
Read a total of 2208 lines from
/usr/local/oracle/product/9.2.0/rdbms/lib/env_rdbms.mk (including
inclusions)
Read a total of 2499 lines from
/usr/local/oracle/product/9.2.0/rdbms/demo/demo_rdbms.mk (including
inclusions)
Deleted SHELL definition: SHELL=/bin/sh
Deleted LIB_EXT definition: LIB_EXT=a
Deleted OBJ_EXT definition: OBJ_EXT=o
Deleted AR definition: AR=ar
Deleted AS definition: AS=as
Deleted CC definition: CC=cc
Deleted CHMOD definition: CHMOD=chmod
Deleted CPP definition: CPP=cpp
Deleted ECHO definition: ECHO=echo
Deleted LD definition: LD=ld
Deleted PERL definition: PERL=perl
Deleted CFLAGS definition: CFLAGS=$(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS)
$(PFLAGS)\
$(SHARED_CFLAG) $(USRFLAGS)
Deleted LDFLAGS definition: LDFLAGS=-o $@ $(LDPATHFLAG)$(PRODLIBHOME)
$(LDPATHFLAG)$(LIBHOME)
LMAKE macro redefined by Oracle
from make
to /usr/ccs/bin/make
FIND macro redefined by Oracle
from find
to /usr/local/bin/find # gnu find!
LINK macro redefined by Oracle
from $(LDCCOM)
to $(ADE_DEL_FILE_CMD) $(PURECMDS) $(LD) $(LDFLAGS) -dy $(COMPSOBJS)
LINKCC macro redefined by Oracle
from $(LDCCOMCC)
to $(ADE_DEL_FILE_CMD) $(PURECMDS) $(CCC)
$(LDFLAGS) -norunpath -mt -nocx -dy $(COMPOBJSCC)
LINKLDLIBS macro redefined by Oracle
from $(LDLIBS)
to $(EXPDLIBS) $(EXOSLIBS) $(SYSLIBS) $(LINKEXSYSLIBS) $(MATHLIB)
$(USRLIBS) $(COMPEOBJS)
COBLDLIBS macro redefined by Oracle
from $(LDLIBS)
to $(EXPDLIBS) $(EXOSLIBS) $(SYSLIBS) $(COBEXSYSLIBS) $(MATHLIB)
$(USRLIBS)
Deleted OPTIMIZE definition: OPTIMIZE=$(OPTIMIZE3)
AR macro redefined by Oracle
from ar
to /usr/ccs/bin/ar
Deleted AR definition: AR=/usr/ccs/bin/ar
AS macro redefined by Oracle
from as
to /usr/ccs/bin/as
Deleted AS definition: AS=/usr/ccs/bin/as
LD macro redefined by Oracle
from ld
to /usr/ccs/bin/ld
Deleted LD definition: LD=/usr/ccs/bin/ld
NM macro redefined by Oracle
from nm
to /usr/ccs/bin/nm
TR macro redefined by Oracle
from tr
to /usr/bin/tr
CPP macro redefined by Oracle
from cpp
to $(CC) -E $(ANSI)
Deleted CPP definition: CPP=$(CC) -E $(ANSI)
TOUCH macro redefined by Oracle
from touch
to /bin/touch
CHMOD macro redefined by Oracle
from chmod
to /bin/chmod
Deleted CHMOD definition: CHMOD=/bin/chmod
Deleted ASFLAGS definition: ASFLAGS=$(NOKPIC_ASFLAGS) $(KPIC_OPTION)
Deleted CCFLAGS definition: CCFLAGS= $(NOKPIC_CCFLAGS) $(KPIC_OPTION)
TOP macro redefined by Oracle
from $(ORACLE_HOME)/precomp
to $(ORACLE_HOME)/slax
LIBNTVI macro redefined by Oracle
from $(NETWORKLIB)$(LIB_PREFIX)$(VINAME).$(SO_EXT)
to $(LIBHOME)$(LIB_PREFIX)$(VINAME).$(LIB_EXT)
LIBNTOD macro redefined by Oracle
from $(NETWORKLIB)$(LIB_PREFIX)$(DCENAME).$(LIB_EXT)
to $(LIBHOME)$(LIB_PREFIX)$(DCENAME).$(LIB_EXT)
LIBCDS macro redefined by Oracle
from $(NETWORKLIB)$(LIB_PREFIX)$(CDSNAME).$(LIB_EXT)
to $(LIBHOME)$(LIB_PREFIX)$(CDSNAME).$(LIB_EXT)
LIBNTLU62 macro redefined by Oracle
from $(NETWORKLIB)$(LIB_PREFIX)$(LU62NAME).$(LIB_EXT)
to $(LIBHOME)$(LIB_PREFIX)$(LU62NAME).$(LIB_EXT)
LIBNTS macro redefined by Oracle
from $(NETWORKLIB)$(LIB_PREFIX)$(SPXNAME).$(LIB_EXT)
to $(LIBHOME)$(LIB_PREFIX)$(SPXNAME).$(LIB_EXT)
LIBNETWORK macro redefined by Oracle
from $(NETWORKLIB)$(LIB_PREFIX)$(COMMONNAME).$(LIB_EXT)
to $(LIBHOME)$(LIB_PREFIX)$(COMMONNAME).$(LIB_EXT)
LIBNSGR macro redefined by Oracle
from $(NETWORKLIB)$(LIB_PREFIX)$(NSGRNAME).$(LIB_EXT)
to $(LIBHOME)$(LIB_PREFIX)$(NSGRNAME).$(LIB_EXT)
LIBNTP macro redefined by Oracle
from $(NETWORKLIB)$(LIB_PREFIX)$(BEQNAME).$(LIB_EXT)
to $(LIBHOME)$(LIB_PREFIX)$(BEQNAME).$(LIB_EXT)
LIBNL macro redefined by Oracle
from $(NETWORKLIB)$(LIB_PREFIX)$(NLNAME).$(LIB_EXT)
to $(LIBHOME)$(LIB_PREFIX)$(NLNAME).$(LIB_EXT)
LIBSSLB macro redefined by Oracle
from $(NETWORKLIB)$(LIB_PREFIX)$(SSLBNAME).$(LIB_EXT)
to $(LIBHOME)$(LIB_PREFIX)$(SSLBNAME).$(LIB_EXT)
LLIBORDSDO macro redefined by Oracle
from $(LDLIBFLAG)$(LIB_PREFIX)$(LIBORDSDONAME).$(LIB_EXT)
to $(LDLIBFLAG)$(LIBORDSDONAME)$(LIB_SUFFIX)
LLIBOCCI macro redefined by Oracle
from $(LDLIBFLAG)$(LIBOCCINAME)$(RDBMS_VERSION)
to $(LDLIBFLAG)$(LIBOCCINAME)
LIBOCCI macro redefined by Oracle
from $(LIBHOME)$(LIB_PREFIX)$(LIBOCCINAME)$(RDBMS_VERSION).$(LIB_EXT)
to $(LIBHOME)$(LIB_PREFIX)$(LIBOCCINAME).$(SO_EXT).$(RDBMS_VERSION).0
Appending '/usr/local/oracle/product/9.2.0/rdbms/lib/libskgxpd.a
/usr/local/oracle/product/9.2.0/rdbms/lib/libskgxpu.a
/usr/local/oracle/product/9.2.0/rdbms/lib/libskgxpt.a' to EXTRALIBS
Appending '$(LIBHOME)libskgxp9.so' to SHLIBS
Appending '/usr/local/oracle/product/9.2.0/rdbms/lib/libskgxp9.a' to LIBS
Appending '/usr/local/oracle/product/9.2.0/rdbms/lib/libskgxns.a
/usr/local/oracle/product/9.2.0/rdbms/lib/libskgxnd.a
/usr/local/oracle/product/9.2.0/rdbms/lib/libskgxnr.a' to EXTRALIBS
Appending '$(LIBHOME)libskgxn9.so' to SHLIBS
Appending '/usr/local/oracle/product/9.2.0/rdbms/lib/libskgxn9.a' to LIBS
Evaluating `cat $(LIBHOME)sysliblist`
expanded `cat /usr/local/oracle/product/9.2.0/lib/sysliblist`
returned '-lnsl -lsocket -lgen -ldl -lsched'
Attempting to discover Oracle OCI build rules...
gcc -B/usr/ccs/bin/ -c -o DBD_ORA_OBJ.o DBD_ORA_OBJ.c
by executing:
make -f /usr/local/oracle/product/9.2.0/rdbms/demo/demo_rdbms.mk build
ECHODO=true ECHO=echo GENCLNTSH='echo genclntsh' CC=echo OPTIMIZE= CCFLAGS=
EXE=DBD_ORA_EXE OBJS=DBD_ORA_OBJ.o
Oracle oci build command:
echo -L/usr/local/oracle/product/9.2.0/lib/ -L/usr/local/oracle/product/9.2.
0/rdbms/lib/ -o DBD_ORA_EXE DBD_ORA_OBJ.o -lclntsh `cat
/usr/local/oracle/product/9.2.0/lib/sysliblist` -R/usr/local/oracle/product/
9.2.0/lib -laio -lposix4 -lkstat -lm -lthread
-L/usr/local/oracle/product/9.2.0/lib/ -L/usr/local/oracle/product/9
.2.0/rdbms/lib/ -o DBD_ORA_EXE
DBD_ORA_OBJ.o -lclntsh -lnsl -lsocket -lgen -ldl -lsched -R/usr/local/oracle
/product/9.2.0/lib -laio -lposix4 -lkstat -lm -lthread
Unable to interpret Oracle oci build commands. Using fallback approach.
System: perl5.008 sunos solaris 5.9 generic sun4u sparc sunw,ultra-5_10
Compiler:
gcc -B/usr/ccs/bin/ -O -fno-strict-aliasing -D_LARGEFILE_SOURCE -D_FILE_OFFS
ET_BITS=64
Linker: /usr/ccs/bin/ld
Sysliblist: -lnsl -lsocket -lgen -ldl -lsched
Oracle makefiles would have used these definitions but we override them:
CC: cc
CFLAGS: $(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS) $(PFLAGS)\
$(SHARED_CFLAG) $(USRFLAGS)
[$(GFLAG) -xO3 $(CDEBUG) $(NOKPIC_CCFLAGS) -K
PIC -I/usr/local/oracle/product/9.2.0/rdbms/demo -I/usr/local/oracle/product
/9.2.0/rdbms/public -I/usr/local/oracle/product/9.2.0/plsql/public -I/usr/lo
cal/oracle/product/9.2.0/network/public -DSLMXMX_ENABLE -DSLTS_ENABLE -D_SVI
D_GETTOD -D_REENTRANT $(LPFLAGS) $(USRFLAGS)]
build: $(CC) $(ORALIBPATH) -o $(EXE) $(OBJS) $(OCISHAREDLIBS)
expanded `cat /usr/local/oracle/product/9.2.0/lib/sysliblist`
[ cc -L$(LIBHOME) -L/usr/local/oracle/product/9.2.0/rdbms/lib/ -o
$(EXE) $(OBJS) -lclntsh $(EXPDLIBS)
$(EXOSLIBS) -lnsl -lsocket -lgen -ldl -lsched -R/usr/local/oracle/product/9.
2.0/lib -laio $(THREADLIBS) -lposix4 -lkstat -lm $(USRLIBS) -lthread]
LDFLAGS: -o $@ $(LDPATHFLAG)$(PRODLIBHOME) $(LDPATHFLAG)$(LIBHOME)
[-o $@ -L/usr/local/oracle/product/9.2.0/rdbms/lib/ -L$(LIBHOME)]
Linking with
/usr/local/oracle/product/9.2.0/rdbms/lib/defopt.o -lclntsh -lnsl -lsocket
-lgen -ldl -lsched -R/usr/local/oracle/product/9.2.0/lib -laio -lposix4 -lks
tat -lm -lthread [from $(DEF_OPT) $(OCISHAREDLIBS)]
MakeMaker (v6.03)
Checking if your kit is complete...
Looks good
ABSTRACT_FROM => q[Oracle.pm]
AUTHOR => q[Tim Bunce ([EMAIL PROTECTED])]
DEFINE => q[]
DIR => []
EXE_FILES => [q[ora_explain]]
INC =>
q[-I/usr/local/oracle/product/9.2.0/rdbms/demo -I/usr/local/oracle/product/9
.2.0/rdbms/public -I/usr/local/oracle/product/9.2.0/plsql/public -I/usr/loca
l/oracle/product/9.2.0/network/public -I/usr/local/oracle/product/9.2.0/rdbm
s/demo -I/usr/local/oracle/product/9.2.0/rdbms/demo -I/usr/local/lib/perl5/s
ite_perl/5.8.0/sun4-solaris/auto/DBI]
LIBS =>
[q[-L/usr/local/oracle/product/9.2.0/lib/ -lclntsh -lnsl -lsocket -lgen -ld
l -lsched -R/usr/local/oracle/product/9.2.0/lib -laio -lposix4 -lkstat -lm -
lthread]]
NAME => q[DBD::Oracle]
OBJECT => q[$(O_FILES)]
PREREQ_PM => { DBI=>q[0] }
VERSION_FROM => q[Oracle.pm]
clean => { FILES=>q[Oracle.xsi dll.base dll.exp sqlnet.log libOracle.def
ora_explain mk.pm] }
dist => { DIST_DEFAULT=>q[clean distcheck disttest ci tardist],
COMPRESS=>q[gzip -v9], PREOP=>q[$(MAKE) -f Makefile.old distdir],
SUFFIX=>q[gz] }
dynamic_lib => { OTHERLDFLAGS=>q[
/usr/local/oracle/product/9.2.0/rdbms/lib/defopt.o $(COMPOBJS)] }
Using PERL=/usr/local/bin/perl
Potential libraries are
'-L/usr/local/oracle/product/9.2.0/lib/ -lclntsh -lnsl -lsocket -lgen -ldl
-lsched -R/usr/local/oracle/product/9.2.0/lib -laio -lposix4 -lkstat -lm -lt
hread':
'-lclntsh' found at /usr/local/oracle/product/9.2.0/lib//libclntsh.so.9.0
nsl not found in /usr/local/oracle/product/9.2.0/lib/
nsl not found in /usr/local/lib
'-lnsl' found at /usr/lib/libnsl.so.1
socket not found in /usr/local/oracle/product/9.2.0/lib/
socket not found in /usr/local/lib
'-lsocket' found at /usr/lib/libsocket.so.1
gen not found in /usr/local/oracle/product/9.2.0/lib/
gen not found in /usr/local/lib
'-lgen' found at /usr/lib/libgen.so.1
dl not found in /usr/local/oracle/product/9.2.0/lib/
dl not found in /usr/local/lib
'-ldl' found at /usr/lib/libdl.so.1
sched not found in /usr/local/oracle/product/9.2.0/lib/
sched not found in /usr/local/lib
'-lsched' found at /usr/lib/libsched.so.1
aio not found in /usr/local/oracle/product/9.2.0/lib/
aio not found in /usr/local/oracle/product/9.2.0/lib
aio not found in /usr/local/lib
'-laio' found at /usr/lib/libaio.so.1
posix4 not found in /usr/local/oracle/product/9.2.0/lib/
posix4 not found in /usr/local/oracle/product/9.2.0/lib
posix4 not found in /usr/local/lib
'-lposix4' found at /usr/lib/libposix4.so.1
kstat not found in /usr/local/oracle/product/9.2.0/lib/
kstat not found in /usr/local/oracle/product/9.2.0/lib
kstat not found in /usr/local/lib
'-lkstat' found at /usr/lib/libkstat.so.1
m not found in /usr/local/oracle/product/9.2.0/lib/
m not found in /usr/local/oracle/product/9.2.0/lib
m not found in /usr/local/lib
'-lm' found at /usr/lib/libm.so.1
thread not found in /usr/local/oracle/product/9.2.0/lib/
thread not found in /usr/local/oracle/product/9.2.0/lib
thread not found in /usr/local/lib
'-lthread' found at /usr/lib/libthread.so.1
LD_RUN_PATH=/usr/local/oracle/product/9.2.0/lib
Using DBD::Oracle 1.12.
Using DBD::Oracle 1.12.
Using DBI 1.32 installed in
/usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris/auto/DBI
Writing Makefile for DBD::Oracle
*** If you have problems...
read all the log printed above, and the README and README.help files.
(Of course, you have read README by now anyway, haven't you?)
> make
cp Oracle.h blib/arch/auto/DBD/Oracle/Oracle.h
cp Oracle.pm blib/lib/DBD/Oracle.pm
cp dbdimp.h blib/arch/auto/DBD/Oracle/dbdimp.h
cp oraperl.ph blib/lib/oraperl.ph
cp ocitrace.h blib/arch/auto/DBD/Oracle/ocitrace.h
cp Oraperl.pm blib/lib/Oraperl.pm
cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm
/usr/local/bin/perl -p -e "s/~DRIVER~/Oracle/g" <
/usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris/auto/DBI/Driver.xst >
Oracle.xsi
/usr/local/bin/perl /usr/local/lib/perl5/5.8.0/ExtUtils/xsubpp -typemap
/usr/local/lib/perl5/5.8.0/ExtUtils/typemap Oracle.xs > Oracle.xsc && mv
Oracle.xsc Oracle.c
gcc -B/usr/ccs/bin/ -c -I/usr/local/oracle/product/9.2.0/rdbms/demo -I/usr/
local/oracle/product/9.2.0/rdbms/public -I/usr/local/oracle/product/9.2.0/pl
sql/public -I/usr/local/oracle/product/9.2.0/network/public -I/usr/local/ora
cle/product/9.2.0/rdbms/demo -I/usr/local/oracle/product/9.2.0/rdbms/demo -I
/usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris/auto/DBI -fno-strict-alias
ing -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -DVERSION=\"1.12\" -DXS_
VERSION=\"1.12\" -fPIC "-I/usr/local/lib/perl5/5.8.0/sun4-solaris/CORE"
Oracle.c
Oracle.xs: In function `XS_DBD__Oracle__st_ora_fetch':
Oracle.xs:69: warning: passing arg 1 of `fprintf' from incompatible pointer
type
Oracle.xs:79: warning: passing arg 1 of `fprintf' from incompatible pointer
type
Oracle.xs:83: warning: passing arg 1 of `fprintf' from incompatible pointer
type
Oracle.xs:87: warning: passing arg 1 of `fprintf' from incompatible pointer
type
gcc -B/usr/ccs/bin/ -c -I/usr/local/oracle/product/9.2.0/rdbms/demo -I/usr/
local/oracle/product/9.2.0/rdbms/public -I/usr/local/oracle/product/9.2.0/pl
sql/public -I/usr/local/oracle/product/9.2.0/network/public -I/usr/local/ora
cle/product/9.2.0/rdbms/demo -I/usr/local/oracle/product/9.2.0/rdbms/demo -I
/usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris/auto/DBI -fno-strict-alias
ing -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -DVERSION=\"1.12\" -DXS_
VERSION=\"1.12\" -fPIC "-I/usr/local/lib/perl5/5.8.0/sun4-solaris/CORE"
dbdimp.c
dbdimp.c: In function `dbd_fbh_dump':
dbdimp.c:85: warning: initialization from incompatible pointer type
dbdimp.c: In function `ora_db_login6':
dbdimp.c:206: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c:212: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c:220: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c:221: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c:222: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c:224: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c:227: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c:228: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c:229: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c:234: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c:236: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c:244: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c:248: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c:249: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c:250: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c:251: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c:252: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c:258: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c: In function `ora_db_commit':
dbdimp.c:348: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c: In function `ora_db_rollback':
dbdimp.c:394: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c: In function `ora_db_disconnect':
dbdimp.c:425: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c:427: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c: In function `ora_db_destroy':
dbdimp.c:454: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c:455: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c:456: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c:457: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c: In function `dbd_preparse':
dbdimp.c:668: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c: In function `dbd_rebind_ph_char':
dbdimp.c:783: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c:785: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c:787: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c:790: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c:855: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c: In function `pp_rebind_ph_rset_in':
dbdimp.c:877: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c:889: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c:895: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c: In function `pp_exec_rset':
dbdimp.c:911: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c:917: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c:921: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c:929: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c:976: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c:986: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c: In function `dbd_rebind_ph':
dbdimp.c:1072: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c:1093: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c:1101: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c:1133: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c: In function `ora_bind_ph':
dbdimp.c:1180: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c:1183: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c:1185: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c:1186: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c: In function `dbd_phs_sv_complete':
dbdimp.c:1284: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c:1294: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c:1302: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c: In function `dbd_phs_avsv_complete':
dbdimp.c:1316: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c: In function `ora_st_execute':
dbdimp.c:1340: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c:1379: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c:1404: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c:1417: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c:1431: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c:1436: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c:1441: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c: In function `ora_st_blob_read':
dbdimp.c:1580: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c: In function `ora_st_rows':
dbdimp.c:1598: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c: In function `ora_st_finish':
dbdimp.c:1648: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c: In function `ora_free_fbh_contents':
dbdimp.c:1680: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c: In function `ora_free_phs_contents':
dbdimp.c:1690: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c: In function `ora_st_destroy':
dbdimp.c:1719: warning: passing arg 1 of `fprintf' from incompatible pointer
type
dbdimp.c: In function `dump_env_to_trace':
dbdimp.c:1935: warning: initialization from incompatible pointer type
gcc -B/usr/ccs/bin/ -c -I/usr/local/oracle/product/9.2.0/rdbms/demo -I/usr/
local/oracle/product/9.2.0/rdbms/public -I/usr/local/oracle/product/9.2.0/pl
sql/public -I/usr/local/oracle/product/9.2.0/network/public -I/usr/local/ora
cle/product/9.2.0/rdbms/demo -I/usr/local/oracle/product/9.2.0/rdbms/demo -I
/usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris/auto/DBI -fno-strict-alias
ing -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -DVERSION=\"1.12\" -DXS_
VERSION=\"1.12\" -fPIC "-I/usr/local/lib/perl5/5.8.0/sun4-solaris/CORE"
oci7.c
gcc -B/usr/ccs/bin/ -c -I/usr/local/oracle/product/9.2.0/rdbms/demo -I/usr/
local/oracle/product/9.2.0/rdbms/public -I/usr/local/oracle/product/9.2.0/pl
sql/public -I/usr/local/oracle/product/9.2.0/network/public -I/usr/local/ora
cle/product/9.2.0/rdbms/demo -I/usr/local/oracle/product/9.2.0/rdbms/demo -I
/usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris/auto/DBI -fno-strict-alias
ing -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -DVERSION=\"1.12\" -DXS_
VERSION=\"1.12\" -fPIC "-I/usr/local/lib/perl5/5.8.0/sun4-solaris/CORE"
oci8.c
oci8.c: In function `oci_error_get':
oci8.c:136: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:144: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c: In function `ora_st_prepare':
oci8.c:304: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:307: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:310: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:314: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:317: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:335: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c: In function `dbd_phs_in':
oci8.c:375: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c: In function `dbd_phs_out':
oci8.c:457: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c: In function `dbd_rebind_ph_lob':
oci8.c:597: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:600: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c: In function `ora_blob_read_piece':
oci8.c:630: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:653: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:658: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:671: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c: In function `fetch_func_autolob':
oci8.c:701: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:740: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:745: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:758: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c: In function `fbh_setup_getrefpv':
oci8.c:783: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:789: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c: In function `ora_describe':
oci8.c:819: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:827: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:833: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:841: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:860: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:866: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:867: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:869: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:870: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:871: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:872: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:935: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:950: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:981: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:992: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:996: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:1026: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:1042: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c: In function `ora_st_fetch':
oci8.c:1073: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:1075: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:1084: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:1101: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:1173: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c: In function `ora_parse_uid':
oci8.c:1201: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:1204: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c: In function `ora_db_reauthenticate':
oci8.c:1220: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:1222: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c: In function `init_lob_refetch':
oci8.c:1359: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:1361: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:1366: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:1368: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:1374: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:1377: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:1381: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:1384: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:1389: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:1397: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:1401: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:1405: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:1410: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:1421: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:1472: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:1486: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:1494: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:1502: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:1516: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:1526: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:1529: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:1534: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:1536: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:1554: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:1556: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c: In function `post_execute_lobs':
oci8.c:1591: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:1596: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:1610: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:1613: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c:1619: warning: passing arg 1 of `fprintf' from incompatible pointer
type
oci8.c: In function `ora_free_lob_refetch':
oci8.c:1637: warning: passing arg 1 of `fprintf' from incompatible pointer
type
Running Mkbootstrap for DBD::Oracle ()
chmod 644 Oracle.bs
rm -f blib/arch/auto/DBD/Oracle/Oracle.so
LD_RUN_PATH="/usr/local/oracle/product/9.2.0/lib"
gcc -B/usr/ccs/bin/ -G -L/usr/local/lib Oracle.o dbdimp.o oci7.o oci8.o
/usr/local/oracle/product/9.2.0/rdbms/lib/defopt.o -o
blib/arch/auto/DBD/Oracle/Oracle.so -L/usr/local/oracle/product/9.2.0/lib/
-lclntsh -lnsl -lsocket -lgen -ldl -lsched -R/usr/local/oracle/product/9.2.
0/lib -laio -lposix4 -lkstat -lm -lthread
chmod 755 blib/arch/auto/DBD/Oracle/Oracle.so
cp Oracle.bs blib/arch/auto/DBD/Oracle/Oracle.bs
chmod 644 blib/arch/auto/DBD/Oracle/Oracle.bs
/usr/local/bin/perl "-Iblib/arch" "-Iblib/lib" ora_explain.PL ora_explain
Extracted ora_explain from ora_explain.PL with variable substitutions.
cp ora_explain blib/script/ora_explain
/usr/local/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)"
blib/script/ora_explain
Manifying blib/man3/DBD::Oracle.3
Manifying blib/man1/ora_explain.1
Manifying blib/man3/DBD::Oraperl.3
> make test TEST_VERBOSE=1
PERL_DL_NONLAZY=1 /usr/local/bin/perl "-MExtUtils::Command::MM" "-e"
"test_harness(1, 'blib/lib', 'blib/arch')" t/*.t
t/base.......1..5
ok 1
ok 2
ok 3
ok 4
ok 5
ok
t/general....1..17
ok 1
ok 2
ok 3
ok 4
ok 5
ok 6
ok 7
ok 8
ok 9
ok 10
ok 11
ok 12
ok 13
ok 14
ok 15
ok 16
ok 17
ok
t/long.......create table dbd_ora__drop_me ( idx integer, lng LONG, dt
date )
1..143
long_data0 length 10240
long_data1 length 81920
long_data2 length 71680
create table dbd_ora__drop_me ( idx integer, lng LONG, dt date )
--- insert some LONG data
ok 1
ok 2
ok 3
ok 4
--- fetch LONG data back again -- truncated - LongTruncOk == 1
LongReadLen 20, LongTruncOk 1
ok 5
ok 6
ok 7
ok 8
ok 9
ok 10
--- fetch LONG data back again -- truncated - LongTruncOk == 0
LongReadLen 81910, LongTruncOk
ok 11
ok 12
ok 13
ok 14
ok 15
ok 16
--- fetch LONG data back again -- complete - LongTruncOk == 0
LongReadLen 82920, LongTruncOk
ok 17
ok 18
ok 19
ok 20
ok 21
ok 22
ok 23
ok 24
--- fetch LONG data back again -- via blob_read
Skipped blob_read tests for LONGs with OCI8 - not currently supported.
ok 25
ok 26
ok 27
ok 28
ok 29
ok 30
ok 31
ok 32
ok 33
ok 34
ok 35
long_data0 length 20480
long_data1 length 81920
long_data2 length 71680
create table dbd_ora__drop_me ( idx integer, lng LONG RAW, dt date )
--- insert some LONG RAW data
ok 36
ok 37
ok 38
ok 39
--- fetch LONG RAW data back again -- truncated - LongTruncOk == 1
LongReadLen 20, LongTruncOk 1
ok 40
ok 41
ok 42
ok 43
ok 44
ok 45
--- fetch LONG RAW data back again -- truncated - LongTruncOk == 0
LongReadLen 40955, LongTruncOk
ok 46
ok 47
ok 48
ok 49
ok 50
ok 51
--- fetch LONG RAW data back again -- complete - LongTruncOk == 0
LongReadLen 82920, LongTruncOk
ok 52
ok 53
ok 54
ok 55
ok 56
ok 57
ok 58
ok 59
--- fetch LONG RAW data back again -- via blob_read
Skipped blob_read tests for LONGs with OCI8 - not currently supported.
ok 60
ok 61
ok 62
ok 63
ok 64
ok 65
ok 66
ok 67
ok 68
ok 69
ok 70
long_data0 length 10240
long_data1 length 81920
long_data2 length 71680
create table dbd_ora__drop_me ( idx integer, lng CLOB, dt date )
--- insert some CLOB data
ok 71
ok 72
ok 73
ok 74
--- fetch CLOB data back again -- truncated - LongTruncOk == 1
LongReadLen 20, LongTruncOk 1
ok 75
ok 76
ok 77
ok 78
ok 79
ok 80
--- fetch CLOB data back again -- truncated - LongTruncOk == 0
LongReadLen 81910, LongTruncOk
ok 81
ok 82
ok 83
ok 84
ok 85
ok 86
--- fetch CLOB data back again -- complete - LongTruncOk == 0
LongReadLen 82920, LongTruncOk
ok 87
ok 88
ok 89
ok 90
ok 91
ok 92
ok 93
ok 94
--- fetch CLOB data back again -- via blob_read
ok 95
ok 96
ok 97
Use of uninitialized value in numeric eq (==) at t/long.t line 230.
# failed test 98 at line 230. ORA-01403: no data found (DBD NEED_DATA:
OCILobRead)
Use of uninitialized value in string eq at t/long.t line 231.
Use of uninitialized value in length at t/long.t line 345.
Use of uninitialized value in string eq at t/long.t line 346.
not ok 98
# failed test 99 at line 231. Strings are of different lengths (0 vs 10240)
# failed test 100 at line 233. ORA-01403: no data found (DBD (UNKNOWN OCI
STATUS 1010): OCIStmtFetch)
not ok 99
not ok 100
dubious
Test returned status 0 (wstat 139, 0x8b)
DIED. FAILED tests 98-143
Failed 46/143 tests, 67.83% okay
t/ph_type....1..53
ok 1
#
# testing VARCHAR2 (ora_type 1) ...
#
ok 2
ok 3
ok 4
ok 5
ok 6
ok 7
ok 8
ok 9
ok 10
ok 11
ok 12
expected 'trailing' but got 'trailing ' for VARCHAR2
# failed test 13 at line 107
not ok 13
ok 14
#
# testing STRING (ora_type 5) ...
#
# skipping tests
ok 15
ok 16
ok 17
ok 18
ok 19
ok 20
ok 21
ok 22
ok 23
ok 24
ok 25
ok 26
#
# testing CHAR (ora_type 96) ...
#
ok 27
ok 28
ok 29
ok 30
ok 31
ok 32
ok 33
ok 34
ok 35
ok 36
ok 37
ok 38
ok 39
#
# testing CHARZ (ora_type 97) ...
#
# skipping tests
ok 40
ok 41
ok 42
ok 43
ok 44
ok 45
ok 46
ok 47
ok 48
ok 49
ok 50
ok 51
ok 52
ok 53
FAILED test 13
Failed 1/53 tests, 98.11% okay
t/plsql......1..63
ok 1
ok 2
ok 3
ok 4
ok 5
ok 6
ok 7
ok 8
ok 9
ok 10
ok 11
ok 12
ok 13
ok 14
ok 15
ok 16
ok 17
ok 18
ok 19
ok 20
ok 21
ok 22
ok 23
ok 24
ok 25
ok 26
ok 27
ok 28
ok 29
ok 30
ok 31
ok 32
ok 33
ok 34
ok 35
ok 36
ok 37
ok 38
ok 39
ok 40
ok 41
ok 42
ok 43
ok 44
ok 45
ok 46
ok 47
ok 48
ok 49
ok 50
ok 51
ok 52
ok 53
ok 54
ok 55
ok 56
ok 57
ok 58
ok 59
ok 60
ok 61
ok 62
ok 63
ok
t/reauth.....ORACLE_USERID_2 not defined.
Tests skiped.
1..0
skipped
all skipped: no reason given
Failed Test Stat Wstat Total Fail Failed List of Failed
----------------------------------------------------------------------------
---
t/long.t 0 139 143 46 32.17% 98-143
t/ph_type.t 53 1 1.89% 13
1 test skipped.
Failed 2/6 test scripts, 66.67% okay. 47/281 subtests failed, 83.27% okay.
make: *** [test_dynamic] Error 29
Software information:
Oracle 9.2.0.2
Solaris 9 Patched.
Perl:
Summary of my perl5 (revision 5.0 version 8 subversion 0) configuration:
Platform:
osname=solaris, osvers=2.9, archname=sun4-solaris
uname='sunos solaris 5.9 generic sun4u sparc sunw,ultra-5_10 '
config_args='-Dcc=gcc -B/usr/ccs/bin/'
hint=recommended, useposix=true, d_sigaction=define
usethreads=undef use5005threads=undef useithreads=undef
usemultiplicity=undef
useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
use64bitint=undef use64bitall=undef uselongdouble=undef
usemymalloc=n, bincompat5005=undef
Compiler:
cc='gcc -B/usr/ccs/bin/', ccflags
='-fno-strict-aliasing -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64',
optimize='-O',
cppflags='-fno-strict-aliasing'
ccversion='', gccversion='3.1', gccosandvers='solaris2.9'
intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=4321
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t',
lseeksize=8
alignbytes=8, prototype=define
Linker and Libraries:
ld='gcc -B/usr/ccs/bin/', ldflags =' -L/usr/local/lib '
libpth=/usr/local/lib /usr/lib /usr/ccs/lib
libs=-lsocket -lnsl -ldb -ldl -lm -lc
perllibs=-lsocket -lnsl -ldl -lm -lc
libc=/lib/libc.so, so=so, useshrplib=false, libperl=libperl.a
gnulibc_version=''
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags=' '
cccdlflags='-fPIC', lddlflags='-G -L/usr/local/lib'
Characteristics of this binary (from libperl):
Compile-time options: USE_LARGE_FILES
Built under solaris
Compiled at Jul 22 2002 04:42:16
%ENV:
PERL_NLS_LANG="ENGLISH_UNITED KINGDOM.WE8ISO8859P1"
@INC:
/usr/local/lib/perl5/5.8.0/sun4-solaris
/usr/local/lib/perl5/5.8.0
/usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris
/usr/local/lib/perl5/site_perl/5.8.0
/usr/local/lib/perl5/site_perl
.
