Hi all,
I'm trying to build DBD-Oracle-1.12 with perl 5.6.1 and Oracle 8.1.7
Things are actually worrking, Adds, deletes ..etc the problem i am having
is with the OCI errors reported by Oracle are not being translated.
A previous version of DBD and perl5.004 seems to work ok but i am not sure
what i am doing wrong with the most recent build.
You can see below the different results returned from the builds when i
generate a bad request to the Oracle DB
Working DBD-Oracle
===================
sql: ;
Report:
Error: ORA-01009: missing mandatory parameter (DBD: error possibly near <*> indicator
at char 1 in '<*>')
Press RETURN to acknowledge or
Not working DBD-Oracle install
===============================
../sql.pl ./sql.pl connected to
sql: ;
Report:
Error: ORA-24373: invalid length specified for statement (DBD ERROR: OCIStmtPrepare)
Press RETURN to acknowledge or QUIT to exit program:
I have attached a copy of perl Makefile.PL -v below.
It looks like the build cannot determine how to use the OCI stuff from
oracle properly or i have not set something
"Unable to interpret Oracle oci build commands. Using fallback approach"
******************* Start of build text
</v/src/perl/modules/DBD/DBD-Oracle-1.12> perl
Makefile.PL -v
Using DBI 1.28 installed in
/usr/local/perl/lib/site_perl/5.6.1/sun4-solaris/auto/DBI
Configuring DBD::Oracle ...
>>> Remember to actually *READ* the README file!
Especially if you have any problems.
Using Oracle in /d/app/oracle/product/8.1.7
Found rdbms/demo/oratypes.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 /d/app/oracle/product/8.1.7/rdbms/demo/demo_rdbms.mk
Found /d/app/oracle/product/8.1.7/otrace/demo/atmoci.mk
Using /d/app/oracle/product/8.1.7/rdbms/demo/demo_rdbms.mk
Reading /d/app/oracle/product/8.1.7/rdbms/demo/demo_rdbms.mk.
Reading /d/app/oracle/product/8.1.7/rdbms/lib/env_rdbms.mk.
Read a total of 2061 lines from
/d/app/oracle/product/8.1.7/rdbms/lib/env_rdbms.mk (including inclusions)
Read a total of 2266 lines from
/d/app/oracle/product/8.1.7/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) $(QACCFLAGS) $(PFLAGS)\
$(SHARED_CFLAG) $(USRFLAGS)
Deleted LDFLAGS definition: LDFLAGS=-o $@ $(LDPATHFLAG)$(PRODLIBHOME)
$(LDPATHFLAG)$(LIBHOME)
STATIC_ORACLETTLIBS macro redefined by Oracle
from $(KPUADEF) $(NTZEOBJ) $(NETLIBS) $(LIBRDBMS_CLT) \
$(LIBMM) $(CORELIBS) $(NETLIBS) $(LIBRDBMS_CLT) $(LIBPLS_CLT) \
$(LIBEPC) $(CORELIBS) $(LIBRDBMS_CLT) $(CORELIBS)
to $(LLIBCLNTST) $(LDFLAGSLIST)
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 $(PURECMDS) $(LD) $(LDFLAGS) -dy $(COMPOBJS)
LINKCC macro redefined by Oracle
from $(LDCCOMCC)
to $(PURECMDS) $(CCC) $(LDFLAGS) -norunpath -mt -nocx -dy $(COMPOBJSCC)
Deleted $(COMPOBJ)/crti.o $(COMPOBJ)/crt1.o $(COMPOBJ)/crtn.o from link
args.
del_crtobj: COMPOBJS=$(COMPOBJ)/crti.o $(COMPOBJ)/crt1.o $(COMPOBJ)/crtn.o
: COMPOBJS=
$(COMPOBJ)/crti.o $(COMPOBJ)/crt1.o $(COMPOBJ)/crtn.o
Edited COMPOBJS definition
from: COMPOBJS=$(COMPOBJ)/crti.o $(COMPOBJ)/crt1.o $(COMPOBJ)/crtn.o
to: COMPOBJS=
LINKLDLIBS macro redefined by Oracle
from $(LDLIBS)
to $(EXPDLIBS) $(EXOSLIBS) $(SYSLIBS) $(LINKEXSYSLIBS) $(MATHLIB)
$(USRLIBS)
COBLDLIBS macro redefined by Oracle
from $(LDLIBS)
to $(EXPDLIBS) $(EXOSLIBS) $(SYSLIBS) $(COBEXSYSLIBS) $(MATHLIB)
$(USRLIBS)
Deleted OPTIMIZE definition: OPTIMIZE=$(OPTIMIZE2)
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)
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)
Deleting ORA_NLS = $(ORACLE_HOME)/ocommon/nls/admin/data/
because it is not already set in the environment
and it can cause ORA-01019 errors.
Deleted ORA_NLS definition: ORA_NLS =
$(ORACLE_HOME)/ocommon/nls/admin/data/
Deleting ORA_NLS33 = $(ORACLE_HOME)/ocommon/nls/admin/data/
because it is not already set in the environment
and it can cause ORA-01019 errors.
Deleted ORA_NLS33 definition: ORA_NLS33 =
$(ORACLE_HOME)/ocommon/nls/admin/data/
Deleted SHELL definition: SHELL=/bin/sh
Deleted LIB_EXT definition: LIB_EXT=a
Deleted OBJ_EXT definition: OBJ_EXT=o
AR macro redefined by Oracle
from /usr/ccs/bin/ar
to ar
Deleted AR definition: AR=ar
AS macro redefined by Oracle
from /usr/ccs/bin/as
to as
Deleted AS definition: AS=as
Deleted CC definition: CC=cc
CHMOD macro redefined by Oracle
from /bin/chmod
to chmod
Deleted CHMOD definition: CHMOD=chmod
CPP macro redefined by Oracle
from $(CC) -E $(ANSI)
to cpp
Deleted CPP definition: CPP=cpp
Deleted ECHO definition: ECHO=echo
FIND macro redefined by Oracle
from /usr/local/bin/find
to find
LD macro redefined by Oracle
from /usr/ccs/bin/ld
to ld
Deleted LD definition: LD=ld
LMAKE macro redefined by Oracle
from /usr/ccs/bin/make
to make
NM macro redefined by Oracle
from /usr/ccs/bin/nm
to nm
Deleted PERL definition: PERL=perl
TR macro redefined by Oracle
from /usr/bin/tr
to tr
Deleted CFLAGS definition: CFLAGS=$(GFLAG) $(OPTIMIZE) $(CDEBUG)
$(CCFLAGS) $(QACCFLAGS) $(PFLAGS)\
$(SHARED_CFLAG) $(USRFLAGS)
LINK macro redefined by Oracle
from $(PURECMDS) $(LD) $(LDFLAGS) -dy $(COMPOBJS)
to $(LDCCOM)
LINKCC macro redefined by Oracle
from $(PURECMDS) $(CCC) $(LDFLAGS) -norunpath -mt -nocx -dy $(COMPOBJSCC)
to $(LDCCOMCC)
Deleted LDFLAGS definition: LDFLAGS=-o $@ $(LDPATHFLAG)$(PRODLIBHOME)
$(LDPATHFLAG)$(LIBHOME)
LINKLDLIBS macro redefined by Oracle
from $(EXPDLIBS) $(EXOSLIBS) $(SYSLIBS) $(LINKEXSYSLIBS) $(MATHLIB)
$(USRLIBS)
to $(LDLIBS)
COBLDLIBS macro redefined by Oracle
from $(EXPDLIBS) $(EXOSLIBS) $(SYSLIBS) $(COBEXSYSLIBS) $(MATHLIB)
$(USRLIBS)
to $(LDLIBS)
STATIC_ORACLETTLIBS macro redefined by Oracle
from $(LLIBCLNTST) $(LDFLAGSLIST)
to $(KPUADEF) $(NTZEOBJ) $(NETLIBS) $(LIBRDBMS_CLT) \
$(LIBMM) $(CORELIBS) $(NETLIBS) $(LIBRDBMS_CLT) $(LIBPLS_CLT) \
$(LIBEPC) $(CORELIBS) $(LIBRDBMS_CLT) $(CORELIBS)
STATIC_ORACLETTLIBS macro redefined by Oracle
from $(KPUADEF) $(NTZEOBJ) $(NETLIBS) $(LIBRDBMS_CLT) \
$(LIBMM) $(CORELIBS) $(NETLIBS) $(LIBRDBMS_CLT) $(LIBPLS_CLT) \
$(LIBEPC) $(CORELIBS) $(LIBRDBMS_CLT) $(CORELIBS)
to $(LLIBCLNTST) $(LDFLAGSLIST)
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 $(PURECMDS) $(LD) $(LDFLAGS) -dy $(COMPOBJS)
LINKCC macro redefined by Oracle
from $(LDCCOMCC)
to $(PURECMDS) $(CCC) $(LDFLAGS) -norunpath -mt -nocx -dy $(COMPOBJSCC)
Deleted $(COMPOBJ)/crti.o $(COMPOBJ)/crt1.o $(COMPOBJ)/crtn.o from link
args.
del_crtobj: COMPOBJS=$(COMPOBJ)/crti.o $(COMPOBJ)/crt1.o $(COMPOBJ)/crtn.o
: COMPOBJS=
$(COMPOBJ)/crti.o $(COMPOBJ)/crt1.o $(COMPOBJ)/crtn.o
Edited COMPOBJS definition
from: COMPOBJS=$(COMPOBJ)/crti.o $(COMPOBJ)/crt1.o $(COMPOBJ)/crtn.o
to: COMPOBJS=
LINKLDLIBS macro redefined by Oracle
from $(LDLIBS)
to $(EXPDLIBS) $(EXOSLIBS) $(SYSLIBS) $(LINKEXSYSLIBS) $(MATHLIB)
$(USRLIBS)
COBLDLIBS macro redefined by Oracle
from $(LDLIBS)
to $(EXPDLIBS) $(EXOSLIBS) $(SYSLIBS) $(COBEXSYSLIBS) $(MATHLIB)
$(USRLIBS)
Deleted OPTIMIZE definition: OPTIMIZE=$(OPTIMIZE2)
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)
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)
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)
Deleted VERSION definition: VERSION=8
TOP macro redefined by Oracle
from $(ORACLE_HOME)/precomp
to $(ORACLE_HOME)/slax
Deleted VERSION definition: VERSION=8
Deleted VERSION definition: VERSION=8
Deleted VERSION definition: VERSION=8
LLIBORDSDO macro redefined by Oracle
from $(LDLIBFLAG)$(LIB_PREFIX)$(LIBORDSDONAME).$(LIB_EXT)
to $(LDLIBFLAG)$(LIBORDSDONAME)$(LIB_SUFFIX)
LDFLAGSLIST macro redefined by Oracle
from `$(CAT) $(LDFLAGSFILE)`
to `$(SED) -e 's/-ljava//g' $(LDFLAGSFILE)`
LIBNM macro redefined by Oracle
from $(LIBDLM)
to $(CLUSTERDIR)/lib/libudlm.so
LLIBNM macro redefined by Oracle
from $(LLIBDLM)
to $(SKGXN) -ludlm
Evaluating `if [ -f /usr/lib/libsched.so ] ; then echo -lsched ; else
true; fi`
returned '-lsched'
Appending '-lsched ' to SYSLIBS
Appending '/d/app/oracle/product/8.1.7/rdbms/lib/libskgxpd.a
/d/app/oracle/product/8.1.7/rdbms/lib/libskgxpu.a /d/app/ora
cle/product/8.1.7/rdbms/lib/libskgxpt.a' to EXTRALIBS
Appending '$(LIBHOME)libskgxp8.so' to SHLIBS
Appending '/d/app/oracle/product/8.1.7/rdbms/lib/libskgxp8.a' to LIBS
ORACLE_LINKLINE macro redefined by Oracle
from $(LINK) $(PL_FLAGS) $(ORAMAI) $(SSORED) $(TTCSOI) $(KPUASVR)\
$(NAETTOBJS) $(CONFIG) $(SPOBJS) $(LLIBSERVER) $(LLIBSKGXP) \
$(LLIBRDBMS_SERVER) $(DEF_OPT) $(LLIBKNLOPT) $(LLIBSLAX)
$(LLIBPLSQL) \
$(LLIBSERVER) $(LLIBRDBMS_SERVER) $(LLIBKNLOPT) $(LLIBSLAX) \
$(LLIBPLSQL) $(NMLIBS) $(LLIBICX) $(LLIBOWSUTL) $(LLIBJAVAVMORJOX)
\
$(LLIBWWG) $(LLIBOBK) $(ORACLETTLIBS1) $(LLIBSERVER) $(SDOLIBS) \
$(CARTLIBS) $(CORELIBS) $(LINKLDLIBS)
to $(LINK) $(PL_FLAGS) $(ORAMAI) $(SSORED) $(TTCSOI) $(KPUASVR)\
$(NAETTOBJS) $(CONFIG) $(SPOBJS) $(LLIBSERVER) $(LLIBSKGXP) \
$(LLIBRDBMS_SERVER) $(DEF_OPT) $(LLIBKNLOPT) $(LLIBSLAX)
$(LLIBPLSQL) \
$(LLIBSERVER) $(LLIBRDBMS_SERVER) $(LLIBKNLOPT) $(LLIBSLAX) \
$(LLIBPLSQL) $(NMLIBS) $(LLIBICX) $(LLIBOWSUTL) $(LLIBJAVAVMORJOX)
\
$(LLIBWWG) $(LLIBOBK) $(NTZEOBJ) $(NETLIBS) $(LLIBRDBMS_SERVER) \
$(LLIBMM) $(CORELIBS) $(NETLIBS) $(LLIBRDBMS_SERVER) $(LIBPLS_CLT)
\
$(LLIBEPC) $(CORELIBS) $(LLIBRDBMS_SERVER) $(CORELIBS)
$(LLIBSERVER) \
$(SDOLIBS) $(CARTLIBS) $(CORELIBS) $(LINKLDLIBS)
LDFLAGS macro redefined by Oracle
from -o $@ $(LDPATHFLAG)$(PRODLIBHOME) $(LDPATHFLAG)$(LIBHOME)
to -L$(LIBHOME) -L$(RDBMSLIB)
Deleted LDFLAGS definition: LDFLAGS=-L$(LIBHOME) -L$(RDBMSLIB)
Evaluating `sed -e 's/-ljava//g' $(LIBHOME)ldflags`
expanded `sed -e 's/-ljava//g' /d/app/oracle/product/8.1.7/lib/ldflags`
returned '-lnbeq8 -lnhost8 -ln8 -lncrypt8 -lnidx8 -ln8 -lncrypt8
-lnus8 -ln8 -lncrypt8 -lnk58 -ln8 -lncrypt8 -lnlda
p8 -lldapclnt8 -lnsslb8 -ln8 -lncrypt8 -ln8 -lncrypt8 -lnoname8 -ln8
-lncrypt8 -lnrad8 -ln8 -lncrypt8 -ln8 -lncry
pt8 -lnsid8 -ln8 -lncrypt8 -lntcp8 -lntcps8 -lnsslb8 -lnent8 -lntcp8
-lntns8
'
expanded `sed -e 's/-ljava//g' /d/app/oracle/product/8.1.7/lib/ldflags`
expanded `sed -e 's/-ljava//g' /d/app/oracle/product/8.1.7/lib/ldflags`
expanded `sed -e 's/-ljava//g' /d/app/oracle/product/8.1.7/lib/ldflags`
Evaluating `cat $(LIBHOME)sysliblist`
expanded `cat /d/app/oracle/product/8.1.7/lib/sysliblist`
returned '-lnsl -lsocket -lgen -ldl -lsched'
Attempting to discover Oracle OCI build rules...
cc -c -I/d/app/oracle/product/8.1.7/rdbms/demo
-I/d/app/oracle/product/8.1.7/rdbms/public -I/d/app/oracle/product/8.1.7/plsql/public
-I/d/app/oracle/product/8.1.7/network/public
-I/d/app/oracle/product/8.1.7/rdbms/demo -I/d/app/oracle/product/8.1.7/rdbms/demo
-I/usr/local/perl/lib/site_perl/5.6.1/sun4-solaris/auto/DBI
-I/usr/local/include -I/opt/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64
-O -DVERSION=\"1.12\"
-DXS_VERSION=\"1.12\" -KPIC -I/usr/local/perl/lib/5.6.1/sun4-solaris/CORE
DBD_ORA_OBJ.c
by executing:
make -f /d/app/oracle/product/8.1.7/rdbms/demo/demo_rdbms.mk build
ECHODO=true ECHO=echo GENCLNTSH='echo genclntsh' CC=ec
ho OPTIMIZE= CCFLAGS= EXE=DBD_ORA_EXE OBJS=DBD_ORA_OBJ.o
Oracle oci build command:
echo -L/d/app/oracle/product/8.1.7/lib/
-L/d/app/oracle/product/8.1.7/rdbms/lib/ -o DBD_ORA_EXE DBD_ORA_OBJ.o -lc
lntsh /d/app/oracle/product/8.1.7/rdbms/lib/kpuadef.o `sed -e
's/-ljava//g' /d/app/oracle/product/8.1.7/lib/ldflags` -ln
sgr8 -lnzjs8 -ln8 -lnl8 -lnro8 `sed -e 's/-ljava//g'
/d/app/oracle/product/8.1.7/lib/ldflags` -lnsgr8 -lnzjs8 -ln8 -lnl8
-lclient8 -lvsn8 -lwtc8 -lcommon8 -lgeneric8 -lwtc8 -lmm -lnls8 -lcore8
-lnls8 -lcore8 -lnls8 `sed -e 's/-ljava//g' /
d/app/oracle/product/8.1.7/lib/ldflags` -lnsgr8 -lnzjs8 -ln8 -lnl8 -lnro8
`sed -e 's/-ljava//g' /d/app/oracle/product/8.1
..7/lib/ldflags` -lnsgr8 -lnzjs8 -ln8 -lnl8 -lclient8 -lvsn8 -lwtc8
-lcommon8 -lgeneric8 -ltrace8 -lnls8 -lcore8 -lnls
8 -lcore8 -lnls8 -lclient8 -lvsn8 -lwtc8 -lcommon8 -lgeneric8 -lnls8
-lcore8 -lnls8 -lcore8 -lnls8 `cat /d/app/or
acle/product/8.1.7/lib/sysliblist` `if [ -f /usr/lib/libsched.so ] ; then
echo -lsched ; else true; fi` -R/d/app/oracle/p
roduct/8.1.7/lib -laio -lposix4 -lkstat -lm -lthread
-L/d/app/oracle/product/8.1.7/lib/
-L/d/app/oracle/product/8.1.7/rdbms/lib/ -o DBD_ORA_EXE DBD_ORA_OBJ.o
-lclntsh
/d/app/oracle/product/8.1.7/rdbms/lib/kpuadef.o -lnbeq8 -lnhost8 -ln8
-lncrypt8 -lnidx8 -ln8 -lncrypt8 -lnus8 -ln8 -lncr
ypt8 -lnk58 -ln8 -lncrypt8 -lnldap8 -lldapclnt8 -lnsslb8 -ln8 -lncrypt8
-ln8 -lncrypt8 -lnoname8 -ln8 -lncrypt8 -lnrad8 -
ln8 -lncrypt8 -ln8 -lncrypt8 -lnsid8 -ln8 -lncrypt8 -lntcp8 -lntcps8
-lnsslb8 -lnent8 -lntcp8 -lntns8 -lnsgr8 -lnzjs8 -ln
8 -lnl8 -lnro8 -lnbeq8 -lnhost8 -ln8 -lncrypt8 -lnidx8 -ln8 -lncrypt8
-lnus8 -ln8 -lncrypt8 -lnk58 -ln8 -lncrypt8 -lnldap
8 -lldapclnt8 -lnsslb8 -ln8 -lncrypt8 -ln8 -lncrypt8 -lnoname8 -ln8
-lncrypt8 -lnrad8 -ln8 -lncrypt8 -ln8 -lncrypt8 -lnsi
d8 -ln8 -lncrypt8 -lntcp8 -lntcps8 -lnsslb8 -lnent8 -lntcp8 -lntns8
-lnsgr8 -lnzjs8 -ln8 -lnl8 -lclient8 -lvsn8 -lwtc8 -l
common8 -lgeneric8 -lwtc8 -lmm -lnls8 -lcore8 -lnls8 -lcore8 -lnls8
-lnbeq8 -lnhost8 -ln8 -lncrypt8 -lnidx8 -ln8 -lncrypt
8 -lnus8 -ln8 -lncrypt8 -lnk58 -ln8 -lncrypt8 -lnldap8 -lldapclnt8
-lnsslb8 -ln8 -lncrypt8 -ln8 -lncrypt8 -lnoname8 -ln8
-lncrypt8 -lnrad8 -ln8 -lncrypt8 -ln8 -lncrypt8 -lnsid8 -ln8 -lncrypt8
-lntcp8 -lntcps8 -lnsslb8 -lnent8 -lntcp8 -lntns8
-lnsgr8 -lnzjs8 -ln8 -lnl8 -lnro8 -lnbeq8 -lnhost8 -ln8 -lncrypt8 -lnidx8
-ln8 -lncrypt8 -lnus8 -ln8 -lncrypt8 -lnk58 -ln
8 -lncrypt8 -lnldap8 -lldapclnt8 -lnsslb8 -ln8 -lncrypt8 -ln8 -lncrypt8
-lnoname8 -ln8 -lncrypt8 -lnrad8 -ln8 -lncrypt8 -
ln8 -lncrypt8 -lnsid8 -ln8 -lncrypt8 -lntcp8 -lntcps8 -lnsslb8 -lnent8
-lntcp8 -lntns8 -lnsgr8 -lnzjs8 -ln8 -lnl8 -lclien
t8 -lvsn8 -lwtc8 -lcommon8 -lgeneric8 -ltrace8 -lnls8 -lcore8 -lnls8
-lcore8 -lnls8 -lclient8 -lvsn8 -lwtc8 -lcommon8 -lg
eneric8 -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 -lnsl -lsocket -lgen -ldl
-lsched -lsched -R/d/app/oracle/product/8.1.7/lib
-laio -lposix4 -lkstat -lm -lthread
Unable to interpret Oracle oci build commands. Using fallback approach.
System: perl5.006001 sunos brid 5.8 generic_108528-08 sun4u sparc
sunw,sun-blade-1000
Compiler: cc -O -I/usr/local/include -I/opt/local/include
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64
Linker: /usr/ucb/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) $(QACCFLAGS)
$(PFLAGS)\
$(SHARED_CFLAG) $(USRFLAGS)
[$(GFLAG) -xO2 $(CDEBUG) -Xa $(PROFILE) -xstrconst -xF $(XS)
-mr -xarch=v8 -xcache=16/32/1:1024/64/1 -xchip=ul
tra -D_REENTRANT -K PIC $(QACCFLAGS)
-I/d/app/oracle/product/8.1.7/rdbms/demo
-I/d/app/oracle/product/8.1.7/rdbms/public
-I/d/app/oracle/product/8.1.7/plsql/public
-I/d/app/oracle/product/8.1.7/network/public -DSLMXMX_ENABLE -DSLTS_ENABLE
-D_
SVID_GETTOD $(LPFLAGS) $(USRFLAGS)]
build: $(CC) $(LDFLAGS) -o $(EXE) $(OBJS) $(OCISHAREDLIBS)
expanded `sed -e 's/-ljava//g' /d/app/oracle/product/8.1.7/lib/ldflags`
expanded `sed -e 's/-ljava//g' /d/app/oracle/product/8.1.7/lib/ldflags`
expanded `sed -e 's/-ljava//g' /d/app/oracle/product/8.1.7/lib/ldflags`
expanded `sed -e 's/-ljava//g' /d/app/oracle/product/8.1.7/lib/ldflags`
expanded `cat /d/app/oracle/product/8.1.7/lib/sysliblist`
[ cc -L$(LIBHOME) -L/d/app/oracle/product/8.1.7/rdbms/lib/ -o
$(EXE) $(OBJS) -lclntsh /d/app/oracle/product/8.
1.7/rdbms/lib/kpuadef.o $(NTZEOBJ) -lnbeq8 -lnhost8 -ln8 -lncrypt8 -lnidx8
-ln8 -lncrypt8 -lnus8 -ln8 -lncrypt8 -lnk58 -l
n8 -lncrypt8 -lnldap8 -lldapclnt8 -lnsslb8 -ln8 -lncrypt8 -ln8 -lncrypt8
-lnoname8 -ln8 -lncrypt8 -lnrad8 -ln8 -lncrypt8
-ln8 -lncrypt8 -lnsid8 -ln8 -lncrypt8 -lntcp8 -lntcps8 -lnsslb8 -lnent8
-lntcp8 -lntns8 -l$(ILIB_PREFIX)nsgr8$(ILIB_SUFFI
X) -l$(ILIB_PREFIX)nzjs8$(ILIB_SUFFIX) -l$(ILIB_PREFIX)n8$(ILIB_SUFFIX)
-l$(ILIB_PREFIX)nl8$(ILIB_SUFFIX) -l$(ILIB_PREFIX
)nro8$(ILIB_SUFFIX) -lnbeq8 -lnhost8 -ln8 -lncrypt8 -lnidx8 -ln8 -lncrypt8
-lnus8 -ln8 -lncrypt8 -lnk58 -ln8 -lncrypt8 -l
nldap8 -lldapclnt8 -lnsslb8 -ln8 -lncrypt8 -ln8 -lncrypt8 -lnoname8 -ln8
-lncrypt8 -lnrad8 -ln8 -lncrypt8 -ln8 -lncrypt8
-lnsid8 -ln8 -lncrypt8 -lntcp8 -lntcps8 -lnsslb8 -lnent8 -lntcp8 -lntns8
-l$(ILIB_PREFIX)nsgr8$(ILIB_SUFFIX) -l$(ILIB_PRE
FIX)nzjs8$(ILIB_SUFFIX) -l$(ILIB_PREFIX)n8$(ILIB_SUFFIX)
-l$(ILIB_PREFIX)nl8$(ILIB_SUFFIX) -lclient8 -lvsn8 -lwtc8 -lcomm
on8 -lgeneric8 -lwtc8 -lmm -lnls8$(LIB_SUFFIX) $(LLIBCV6) -lcore8
-lnls8$(LIB_SUFFIX) -lcore8 -lnls8$(LIB_SUFFIX) -lnbeq8
-lnhost8 -ln8 -lncrypt8 -lnidx8 -ln8 -lncrypt8 -lnus8 -ln8 -lncrypt8
-lnk58 -ln8 -lncrypt8 -lnldap8 -lldapclnt8 -lnsslb8
-ln8 -lncrypt8 -ln8 -lncrypt8 -lnoname8 -ln8 -lncrypt8 -lnrad8 -ln8
-lncrypt8 -ln8 -lncrypt8 -lnsid8 -ln8 -lncrypt8 -lnt
cp8 -lntcps8 -lnsslb8 -lnent8 -lntcp8 -lntns8
-l$(ILIB_PREFIX)nsgr8$(ILIB_SUFFIX) -l$(ILIB_PREFIX)nzjs8$(ILIB_SUFFIX)
-l$
(ILIB_PREFIX)n8$(ILIB_SUFFIX) -l$(ILIB_PREFIX)nl8$(ILIB_SUFFIX)
-l$(ILIB_PREFIX)nro8$(ILIB_SUFFIX) -lnbeq8 -lnhost8 -ln8
-lncrypt8 -lnidx8 -ln8 -lncrypt8 -lnus8 -ln8 -lncrypt8 -lnk58 -ln8
-lncrypt8 -lnldap8 -lldapclnt8 -lnsslb8 -ln8 -lncrypt8
-ln8 -lncrypt8 -lnoname8 -ln8 -lncrypt8 -lnrad8 -ln8 -lncrypt8 -ln8
-lncrypt8 -lnsid8 -ln8 -lncrypt8 -lntcp8 -lntcps8 -l
nsslb8 -lnent8 -lntcp8 -lntns8 -l$(ILIB_PREFIX)nsgr8$(ILIB_SUFFIX)
-l$(ILIB_PREFIX)nzjs8$(ILIB_SUFFIX) -l$(ILIB_PREFIX)n8
$(ILIB_SUFFIX) -l$(ILIB_PREFIX)nl8$(ILIB_SUFFIX) -lclient8 -lvsn8 -lwtc8
-lcommon8 -lgeneric8 $(LIBPLS_CLT) -ltrace8$(LIB
_SUFFIX) -lnls8$(LIB_SUFFIX) $(LLIBCV6) -lcore8 -lnls8$(LIB_SUFFIX)
-lcore8 -lnls8$(LIB_SUFFIX) -lclient8 -lvsn8 -lwtc8 -
lcommon8 -lgeneric8 -lnls8$(LIB_SUFFIX) $(LLIBCV6) -lcore8
-lnls8$(LIB_SUFFIX) -lcore8 -lnls8$(LIB_SUFFIX) $(EXPDLIBS) $(
EXOSLIBS) -lnsl -lsocket -lgen -ldl -lsched -lsched
-R/d/app/oracle/product/8.1.7/lib -laio $(THREADLIBS) -lposix4 -lksta
t -lm $(USRLIBS) -lthread]
LDFLAGS: -L$(LIBHOME) -L$(RDBMSLIB)
[-L$(LIBHOME) -L/d/app/oracle/product/8.1.7/rdbms/lib/]
Linking with /d/app/oracle/product/8.1.7/rdbms/lib/ssdbaed.o
/d/app/oracle/product/8.1.7/rdbms/lib/defopt.o /d/app/oracle
/product/8.1.7/rdbms/lib/kpuadef.o -lclntsh -lnbeq8 -lnhost8 -ln8
-lncrypt8 -lnidx8 -ln8 -lncrypt8 -lnus8 -ln8 -lncryp
t8 -lnk58 -ln8 -lncrypt8 -lnldap8 -lldapclnt8 -lnsslb8 -ln8 -lncrypt8 -ln8
-lncrypt8 -lnoname8 -ln8 -lncrypt8 -lnrad8 -ln
8 -lncrypt8 -ln8 -lncrypt8 -lnsid8 -ln8 -lncrypt8 -lntcp8 -lntcps8
-lnsslb8 -lnent8 -lntcp8 -lntns8 -lnsgr8 -lnzjs8 -ln8
-lnl8 -lnro8 -lnbeq8 -lnhost8 -ln8 -lncrypt8 -lnidx8 -ln8 -lncrypt8 -lnus8
-ln8 -lncrypt8 -lnk58 -ln8 -lncrypt8 -lnldap8
-lldapclnt8 -lnsslb8 -ln8 -lncrypt8 -ln8 -lncrypt8 -lnoname8 -ln8
-lncrypt8 -lnrad8 -ln8 -lncrypt8 -ln8 -lncrypt8 -lnsid8
-ln8 -lncrypt8 -lntcp8 -lntcps8 -lnsslb8 -lnent8 -lntcp8 -lntns8 -lnsgr8
-lnzjs8 -ln8 -lnl8 -lclient8 -lvsn8 -lwtc8 -lco
mmon8 -lgeneric8 -lwtc8 -lmm -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 -lnbeq8
-lnhost8 -ln8 -lncrypt8 -lnidx8 -ln8 -lncrypt8
-lnus8 -ln8 -lncrypt8 -lnk58 -ln8 -lncrypt8 -lnldap8 -lldapclnt8 -lnsslb8
-ln8 -lncrypt8 -ln8 -lncrypt8 -lnoname8 -ln8 -l
ncrypt8 -lnrad8 -ln8 -lncrypt8 -ln8 -lncrypt8 -lnsid8 -ln8 -lncrypt8
-lntcp8 -lntcps8 -lnsslb8 -lnent8 -lntcp8 -lntns8 -l
nsgr8 -lnzjs8 -ln8 -lnl8 -lnro8 -lnbeq8 -lnhost8 -ln8 -lncrypt8 -lnidx8
-ln8 -lncrypt8 -lnus8 -ln8 -lncrypt8 -lnk58 -ln8
-lncrypt8 -lnldap8 -lldapclnt8 -lnsslb8 -ln8 -lncrypt8 -ln8 -lncrypt8
-lnoname8 -ln8 -lncrypt8 -lnrad8 -ln8 -lncrypt8 -ln
8 -lncrypt8 -lnsid8 -ln8 -lncrypt8 -lntcp8 -lntcps8 -lnsslb8 -lnent8
-lntcp8 -lntns8 -lnsgr8 -lnzjs8 -ln8 -lnl8 -lclient8
-lvsn8 -lwtc8 -lcommon8 -lgeneric8 -ltrace8 -lnls8 -lcore8 -lnls8 -lcore8
-lnls8 -lclient8 -lvsn8 -lwtc8 -lcommon8 -lgen
eric8 -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 -lnsl -lsocket -lgen -ldl
-lsched -lsched -R/d/app/oracle/product/8.1.7/lib -l
aio -lposix4 -lkstat -lm -lthread [from $(SSDBED) $(DEF_OPT)
$(OCISHAREDLIBS)]
Warning: If you have problems you may need to rebuild perl with
-Uusemymalloc.
MakeMaker (v5.45)
ABSTRACT_FROM => q[Oracle.pm]
AUTHOR => q[Tim Bunce ([EMAIL PROTECTED])]
DEFINE => q[]
DIR => []
EXE_FILES => [q[ora_explain]]
INC => q[-I/d/app/oracle/product/8.1.7/rdbms/demo
-I/d/app/oracle/product/8.1.7/rdbms/public -I/d/app/oracle/prod
uct/8.1.7/plsql/public -I/d/app/oracle/product/8.1.7/network/public
-I/d/app/oracle/product/8.1.7/rdbms/demo -I/d/app/ora
cle/product/8.1.7/rdbms/demo
-I/usr/local/perl/lib/site_perl/5.6.1/sun4-solaris/auto/DBI]
LIBS => [q[-L/d/app/oracle/product/8.1.7/lib/ -lclntsh -lnbeq8
-lnhost8 -ln8 -lncrypt8 -lnidx8 -ln8 -lncrypt8
-lnus8 -ln8 -lncrypt8 -lnk58 -ln8 -lncrypt8 -lnldap8 -lldapclnt8 -lnsslb8
-ln8 -lncrypt8 -ln8 -lncrypt8 -lnoname8 -ln8 -l
ncrypt8 -lnrad8 -ln8 -lncrypt8 -ln8 -lncrypt8 -lnsid8 -ln8 -lncrypt8
-lntcp8 -lntcps8 -lnsslb8 -lnent8 -lntcp8 -lntns8 -l
nsgr8 -lnzjs8 -ln8 -lnl8 -lnro8 -lnbeq8 -lnhost8 -ln8 -lncrypt8 -lnidx8
-ln8 -lncrypt8 -lnus8 -ln8 -lncrypt8 -lnk58 -ln8
-lncrypt8 -lnldap8 -lldapclnt8 -lnsslb8 -ln8 -lncrypt8 -ln8 -lncrypt8
-lnoname8 -ln8 -lncrypt8 -lnrad8 -ln8 -lncrypt8 -ln
8 -lncrypt8 -lnsid8 -ln8 -lncrypt8 -lntcp8 -lntcps8 -lnsslb8 -lnent8
-lntcp8 -lntns8 -lnsgr8 -lnzjs8 -ln8 -lnl8 -lclient8
-lvsn8 -lwtc8 -lcommon8 -lgeneric8 -lwtc8 -lmm -lnls8 -lcore8 -lnls8
-lcore8 -lnls8 -lnbeq8 -lnhost8 -ln8 -lncrypt8 -lni
dx8 -ln8 -lncrypt8 -lnus8 -ln8 -lncrypt8 -lnk58 -ln8 -lncrypt8 -lnldap8
-lldapclnt8 -lnsslb8 -ln8 -lncrypt8 -ln8 -lncrypt
8 -lnoname8 -ln8 -lncrypt8 -lnrad8 -ln8 -lncrypt8 -ln8 -lncrypt8 -lnsid8
-ln8 -lncrypt8 -lntcp8 -lntcps8 -lnsslb8 -lnent8
-lntcp8 -lntns8 -lnsgr8 -lnzjs8 -ln8 -lnl8 -lnro8 -lnbeq8 -lnhost8 -ln8
-lncrypt8 -lnidx8 -ln8 -lncrypt8 -lnus8 -ln8 -ln
crypt8 -lnk58 -ln8 -lncrypt8 -lnldap8 -lldapclnt8 -lnsslb8 -ln8 -lncrypt8
-ln8 -lncrypt8 -lnoname8 -ln8 -lncrypt8 -lnrad8
-ln8 -lncrypt8 -ln8 -lncrypt8 -lnsid8 -ln8 -lncrypt8 -lntcp8 -lntcps8
-lnsslb8 -lnent8 -lntcp8 -lntns8 -lnsgr8 -lnzjs8 -
ln8 -lnl8 -lclient8 -lvsn8 -lwtc8 -lcommon8 -lgeneric8 -ltrace8 -lnls8
-lcore8 -lnls8 -lcore8 -lnls8 -lclient8 -lvsn8 -lw
tc8 -lcommon8 -lgeneric8 -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 -lnsl
-lsocket -lgen -ldl -lsched -lsched -R/d/app/oracle/p
roduct/8.1.7/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],
PREOP=>q[$(MAKE) -f Makefile.old distdir], COMPRE
SS=>q[gzip -v9], SUFFIX=>q[gz] }
dynamic_lib => { OTHERLDFLAGS=>q[
/d/app/oracle/product/8.1.7/rdbms/lib/ssdbaed.o
/d/app/oracle/product/8.1.7/rdb
ms/lib/defopt.o /d/app/oracle/product/8.1.7/rdbms/lib/kpuadef.o
$(COMPOBJS)] }
Using PERL=/usr/local/bin/perl
Potential libraries are '-L/d/app/oracle/product/8.1.7/lib/ -lclntsh
-lnbeq8 -lnhost8 -ln8 -lncrypt8 -lnidx8 -ln8 -lnc
rypt8 -lnus8 -ln8 -lncrypt8 -lnk58 -ln8 -lncrypt8 -lnldap8 -lldapclnt8
-lnsslb8 -ln8 -lncrypt8 -ln8 -lncrypt8 -lnoname8 -
ln8 -lncrypt8 -lnrad8 -ln8 -lncrypt8 -ln8 -lncrypt8 -lnsid8 -ln8 -lncrypt8
-lntcp8 -lntcps8 -lnsslb8 -lnent8 -lntcp8 -lnt
ns8 -lnsgr8 -lnzjs8 -ln8 -lnl8 -lnro8 -lnbeq8 -lnhost8 -ln8 -lncrypt8
-lnidx8 -ln8 -lncrypt8 -lnus8 -ln8 -lncrypt8 -lnk58
-ln8 -lncrypt8 -lnldap8 -lldapclnt8 -lnsslb8 -ln8 -lncrypt8 -ln8
-lncrypt8 -lnoname8 -ln8 -lncrypt8 -lnrad8 -ln8 -lncryp
t8 -ln8 -lncrypt8 -lnsid8 -ln8 -lncrypt8 -lntcp8 -lntcps8 -lnsslb8 -lnent8
-lntcp8 -lntns8 -lnsgr8 -lnzjs8 -ln8 -lnl8 -lc
lient8 -lvsn8 -lwtc8 -lcommon8 -lgeneric8 -lwtc8 -lmm -lnls8 -lcore8
-lnls8 -lcore8 -lnls8 -lnbeq8 -lnhost8 -ln8 -lncrypt
8 -lnidx8 -ln8 -lncrypt8 -lnus8 -ln8 -lncrypt8 -lnk58 -ln8 -lncrypt8
-lnldap8 -lldapclnt8 -lnsslb8 -ln8 -lncrypt8 -ln8 -l
ncrypt8 -lnoname8 -ln8 -lncrypt8 -lnrad8 -ln8 -lncrypt8 -ln8 -lncrypt8
-lnsid8 -ln8 -lncrypt8 -lntcp8 -lntcps8 -lnsslb8 -
lnent8 -lntcp8 -lntns8 -lnsgr8 -lnzjs8 -ln8 -lnl8 -lnro8 -lnbeq8 -lnhost8
-ln8 -lncrypt8 -lnidx8 -ln8 -lncrypt8 -lnus8 -l
n8 -lncrypt8 -lnk58 -ln8 -lncrypt8 -lnldap8 -lldapclnt8 -lnsslb8 -ln8
-lncrypt8 -ln8 -lncrypt8 -lnoname8 -ln8 -lncrypt8 -
lnrad8 -ln8 -lncrypt8 -ln8 -lncrypt8 -lnsid8 -ln8 -lncrypt8 -lntcp8
-lntcps8 -lnsslb8 -lnent8 -lntcp8 -lntns8 -lnsgr8 -ln
zjs8 -ln8 -lnl8 -lclient8 -lvsn8 -lwtc8 -lcommon8 -lgeneric8 -ltrace8
-lnls8 -lcore8 -lnls8 -lcore8 -lnls8 -lclient8 -lvs
n8 -lwtc8 -lcommon8 -lgeneric8 -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 -lnsl
-lsocket -lgen -ldl -lsched -lsched -R/d/app/or
acle/product/8.1.7/lib -laio -lposix4 -lkstat -lm -lthread':
nsl not found in /d/app/oracle/product/8.1.7/lib/
nsl not found in /usr/local/lib
nsl not found in /opt/local/lib
nsl not found in /opt/SUNWspro/SC5.0/lib
'-lnsl' found at /usr/lib/libnsl.so.1
socket not found in /d/app/oracle/product/8.1.7/lib/
socket not found in /usr/local/lib
socket not found in /opt/local/lib
socket not found in /opt/SUNWspro/SC5.0/lib
'-lsocket' found at /usr/lib/libsocket.so.1
gen not found in /d/app/oracle/product/8.1.7/lib/
gen not found in /usr/local/lib
gen not found in /opt/local/lib
gen not found in /opt/SUNWspro/SC5.0/lib
'-lgen' found at /usr/lib/libgen.so.1
dl not found in /d/app/oracle/product/8.1.7/lib/
dl not found in /usr/local/lib
dl not found in /opt/local/lib
dl not found in /opt/SUNWspro/SC5.0/lib
'-ldl' found at /usr/lib/libdl.so.1
sched not found in /d/app/oracle/product/8.1.7/lib/
sched not found in /usr/local/lib
sched not found in /opt/local/lib
sched not found in /opt/SUNWspro/SC5.0/lib
'-lsched' found at /usr/lib/libsched.so.1
sched not found in /d/app/oracle/product/8.1.7/lib/
sched not found in /usr/local/lib
sched not found in /opt/local/lib
sched not found in /opt/SUNWspro/SC5.0/lib
'-lsched' found at /usr/lib/libsched.so.1
aio not found in /d/app/oracle/product/8.1.7/lib/
aio not found in /d/app/oracle/product/8.1.7/lib
aio not found in /usr/local/lib
aio not found in /opt/local/lib
aio not found in /opt/SUNWspro/SC5.0/lib
'-laio' found at /usr/lib/libaio.so.1
posix4 not found in /d/app/oracle/product/8.1.7/lib/
posix4 not found in /d/app/oracle/product/8.1.7/lib
posix4 not found in /usr/local/lib
posix4 not found in /opt/local/lib
posix4 not found in /opt/SUNWspro/SC5.0/lib
'-lposix4' found at /usr/lib/libposix4.so.1
kstat not found in /d/app/oracle/product/8.1.7/lib/
kstat not found in /d/app/oracle/product/8.1.7/lib
kstat not found in /usr/local/lib
kstat not found in /opt/local/lib
kstat not found in /opt/SUNWspro/SC5.0/lib
'-lkstat' found at /usr/lib/libkstat.so.1
m not found in /d/app/oracle/product/8.1.7/lib/
m not found in /d/app/oracle/product/8.1.7/lib
m not found in /usr/local/lib
m not found in /opt/local/lib
'-lm' found at /opt/SUNWspro/SC5.0/lib/libm.so.1
thread not found in /d/app/oracle/product/8.1.7/lib/
thread not found in /d/app/oracle/product/8.1.7/lib
thread not found in /usr/local/lib
thread not found in /opt/local/lib
thread not found in /opt/SUNWspro/SC5.0/lib
'-lthread' found at /usr/lib/libthread.so.1
LD_RUN_PATH=/d/app/oracle/product/8.1.7/lib:/usr/lib:/opt/SUNWspro/SC5.0/lib
Using DBD::Oracle 1.12.
Using DBI 1.28 installed in
/usr/local/perl/lib/site_perl/5.6.1/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?)
root@earthrise1:
</v/src/perl/modules/DBD/DBD-Oracle-1.12> make
cp oraperl.ph blib/lib/oraperl.ph
cp Oracle.pm blib/lib/DBD/Oracle.pm
cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm
cp dbdimp.h blib/arch/auto/DBD/Oracle/dbdimp.h
cp ocitrace.h blib/arch/auto/DBD/Oracle/ocitrace.h
cp Oracle.h blib/arch/auto/DBD/Oracle/Oracle.h
cp Oraperl.pm blib/lib/Oraperl.pm
/usr/local/bin/perl -p -e "s/~DRIVER~/Oracle/g" <
/usr/local/perl/lib/site_perl/5.6.1/sun4-solaris/auto/DBI/Driver.xst >
Oracle.xsi
/usr/local/bin/perl -I/usr/local/perl/lib/5.6.1/sun4-solaris
-I/usr/local/perl/lib/5.6.1 /usr/local/perl/lib/5.6.1/ExtUti
ls/xsubpp -typemap /usr/local/perl/lib/5.6.1/ExtUtils/typemap Oracle.xs >
Oracle.xsc && mv Oracle.xsc Oracle.c
cc -c -I/d/app/oracle/product/8.1.7/rdbms/demo
-I/d/app/oracle/product/8.1.7/rdbms/public -I/d/app/oracle/product/8.1.7/p
lsql/public -I/d/app/oracle/product/8.1.7/network/public
-I/d/app/oracle/product/8.1.7/rdbms/demo -I/d/app/oracle/product
/8.1.7/rdbms/demo
-I/usr/local/perl/lib/site_perl/5.6.1/sun4-solaris/auto/DBI
-I/usr/local/include -I/opt/local/include -
D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -DVERSION=\"1.12\"
-DXS_VERSION=\"1.12\" -KPIC -I/usr/local/perl/lib/5.6
..1/sun4-solaris/CORE Oracle.c
cc -c -I/d/app/oracle/product/8.1.7/rdbms/demo
-I/d/app/oracle/product/8.1.7/rdbms/public -I/d/app/oracle/product/8.1.7/p
lsql/public -I/d/app/oracle/product/8.1.7/network/public
-I/d/app/oracle/product/8.1.7/rdbms/demo -I/d/app/oracle/product
/8.1.7/rdbms/demo
-I/usr/local/perl/lib/site_perl/5.6.1/sun4-solaris/auto/DBI
-I/usr/local/include -I/opt/local/include -
D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -DVERSION=\"1.12\"
-DXS_VERSION=\"1.12\" -KPIC -I/usr/local/perl/lib/5.6
..1/sun4-solaris/CORE dbdimp.c
cc -c -I/d/app/oracle/product/8.1.7/rdbms/demo
-I/d/app/oracle/product/8.1.7/rdbms/public -I/d/app/oracle/product/8.1.7/p
lsql/public -I/d/app/oracle/product/8.1.7/network/public
-I/d/app/oracle/product/8.1.7/rdbms/demo -I/d/app/oracle/product
/8.1.7/rdbms/demo
-I/usr/local/perl/lib/site_perl/5.6.1/sun4-solaris/auto/DBI
-I/usr/local/include -I/opt/local/include -
D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -DVERSION=\"1.12\"
-DXS_VERSION=\"1.12\" -KPIC -I/usr/local/perl/lib/5.6
..1/sun4-solaris/CORE oci7.c
cc -c -I/d/app/oracle/product/8.1.7/rdbms/demo
-I/d/app/oracle/product/8.1.7/rdbms/public -I/d/app/oracle/product/8.1.7/p
lsql/public -I/d/app/oracle/product/8.1.7/network/public
-I/d/app/oracle/product/8.1.7/rdbms/demo -I/d/app/oracle/product
/8.1.7/rdbms/demo
-I/usr/local/perl/lib/site_perl/5.6.1/sun4-solaris/auto/DBI
-I/usr/local/include -I/opt/local/include -
D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -DVERSION=\"1.12\"
-DXS_VERSION=\"1.12\" -KPIC -I/usr/local/perl/lib/5.6
..1/sun4-solaris/CORE oci8.c
"oci8.c", line 267: warning: assignment type mismatch:
pointer to function(pointer to struct imp_dbh_st {struct {..}
com, pointer to function(pointer to struct imp_dbh
_st {..}, int, int) returning pointer to void get_oci_handle, pointer to
struct OCIEnv {..} envhp, pointer to struct OCIE
rror {..} errhp, pointer to struct OCIServer {..} srvhp, pointer to struct
OCISvcCtx {..} svchp, pointer to struct OCISes
sion {..} authp, int RowCacheSize, int ph_type}, int, int) returning
pointer to void "=" pointer to void
Running Mkbootstrap for DBD::Oracle ()
chmod 644 Oracle.bs
rm -f blib/arch/auto/DBD/Oracle/Oracle.so
LD_RUN_PATH="/d/app/oracle/product/8.1.7/lib:/usr/lib:/opt/SUNWspro/SC5.0/lib"
cc -G -L/usr/local/lib -L/opt/local/lib -
L/opt/SUNWspro/SC5.0/lib Oracle.o dbdimp.o oci7.o oci8.o
/d/app/oracle/product/8.1.7/rdbms/lib/ssdbaed.o /d/app/oracle
/product/8.1.7/rdbms/lib/defopt.o
/d/app/oracle/product/8.1.7/rdbms/lib/kpuadef.o -o
blib/arch/auto/DBD/Oracle/Oracle.so
-L/d/app/oracle/product/8.1.7/lib/ -lclntsh -lnbeq8 -lnhost8 -ln8
-lncrypt8 -lnidx8 -ln8 -lncrypt8 -lnus8 -ln8 -lncryp
t8 -lnk58 -ln8 -lncrypt8 -lnldap8 -lldapclnt8 -lnsslb8 -ln8 -lncrypt8 -ln8
-lncrypt8 -lnoname8 -ln8 -lncrypt8 -lnrad8 -ln
8 -lncrypt8 -ln8 -lncrypt8 -lnsid8 -ln8 -lncrypt8 -lntcp8 -lntcps8
-lnsslb8 -lnent8 -lntcp8 -lntns8 -lnsgr8 -lnzjs8 -ln8
-lnl8 -lnro8 -lnbeq8 -lnhost8 -ln8 -lncrypt8 -lnidx8 -ln8 -lncrypt8 -lnus8
-ln8 -lncrypt8 -lnk58 -ln8 -lncrypt8 -lnldap8
-lldapclnt8 -lnsslb8 -ln8 -lncrypt8 -ln8 -lncrypt8 -lnoname8 -ln8
-lncrypt8 -lnrad8 -ln8 -lncrypt8 -ln8 -lncrypt8 -lnsid8
-ln8 -lncrypt8 -lntcp8 -lntcps8 -lnsslb8 -lnent8 -lntcp8 -lntns8 -lnsgr8
-lnzjs8 -ln8 -lnl8 -lclient8 -lvsn8 -lwtc8 -lco
mmon8 -lgeneric8 -lwtc8 -lmm -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 -lnbeq8
-lnhost8 -ln8 -lncrypt8 -lnidx8 -ln8 -lncrypt8
-lnus8 -ln8 -lncrypt8 -lnk58 -ln8 -lncrypt8 -lnldap8 -lldapclnt8 -lnsslb8
-ln8 -lncrypt8 -ln8 -lncrypt8 -lnoname8 -ln8 -l
ncrypt8 -lnrad8 -ln8 -lncrypt8 -ln8 -lncrypt8 -lnsid8 -ln8 -lncrypt8
-lntcp8 -lntcps8 -lnsslb8 -lnent8 -lntcp8 -lntns8 -l
nsgr8 -lnzjs8 -ln8 -lnl8 -lnro8 -lnbeq8 -lnhost8 -ln8 -lncrypt8 -lnidx8
-ln8 -lncrypt8 -lnus8 -ln8 -lncrypt8 -lnk58 -ln8
-lncrypt8 -lnldap8 -lldapclnt8 -lnsslb8 -ln8 -lncrypt8 -ln8 -lncrypt8
-lnoname8 -ln8 -lncrypt8 -lnrad8 -ln8 -lncrypt8 -ln
8 -lncrypt8 -lnsid8 -ln8 -lncrypt8 -lntcp8 -lntcps8 -lnsslb8 -lnent8
-lntcp8 -lntns8 -lnsgr8 -lnzjs8 -ln8 -lnl8 -lclient8
-lvsn8 -lwtc8 -lcommon8 -lgeneric8 -ltrace8 -lnls8 -lcore8 -lnls8 -lcore8
-lnls8 -lclient8 -lvsn8 -lwtc8 -lcommon8 -lgen
eric8 -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 -lnsl -lsocket -lgen -ldl
-lsched -lsched -R/d/app/oracle/product/8.1.7/lib -l
aio -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
-I/usr/local/perl/lib/5.6.1/sun4-solaris -I/usr/local/perl/lib/5.6.1
ora_expla
in.PL ora_explain
Extracted ora_explain from ora_explain.PL with variable substitutions.
cp ora_explain blib/script/ora_explain
/usr/local/bin/perl -I/usr/local/perl/lib/5.6.1/sun4-solaris
-I/usr/local/perl/lib/5.6.1 -MExtUtils::MakeMaker -e "MY->f
ixin(shift)" blib/script/ora_explain
Manifying blib/man3/DBD::Oracle.3
Manifying blib/man1/ora_explain.1
Manifying blib/man3/DBD::Oraperl.3
root@earthrise1:
</v/src/perl/modules/DBD/DBD-Oracle-1.12> make test
PERL_DL_NONLAZY=1 /usr/local/bin/perl -Iblib/arch -Iblib/lib
-I/usr/local/perl/lib/5.6.1/sun4-solaris -I/usr/local/perl/l
ib/5.6.1 -e 'use Test::Harness qw(&runtests $verbose); $verbose=0;
runtests @ARGV;' t/*.t
t/base..............ok
t/general...........ok
t/long..............ok
t/ph_type...........ok
t/plsql.............ok
t/reauth............skipped test on this platform
All tests successful, 1 test skipped.
Files=6, Tests=281, 15 wallclock secs ( 1.61 cusr + 0.54 csys = 2.15
CPU)
PERL_DL_NONLAZY=1 /usr/local/bin/perl -Iblib/arch -Iblib/lib
-I/usr/local/perl/lib/5.6.1/sun4-solaris -I/usr/local/perl/l
ib/5.6.1 test.pl
Oraperl test application $Revision: 1.4 $
Oraperl emulation interface version 1.41
DBD::Oracle 1.12 using OCI8 by Tim Bunce
DBI 1.28 by Tim Bunce
Data sources:
dbi:Oracle:MIRU_EARTHRISE1.ITS.UTAS.EDU.AU
dbi:Oracle:USSPROD.ITS.UTAS.EDU.AU
Connecting
to '' (from command line, else uses ORACLE_SID or TWO_TASK - recommended)
as
'xxx/yyy@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.yyy.utas.edu.au)(PORT=1523))(CONNECT_DATA=(SID=
USSPROD)))' (via ORACLE_USERID env var or default - recommend
name/passwd@dbname)
(ORACLE_SID='', TWO_TASK='xxx/yyy')
Testing internal row fetch overhead.
50000 fetches: 1 wallclock secs ( 0.60 usr + 0.00 sys = 0.60 CPU)
50000 per clock second, 83333 per cpu second
Fields: 6
Names: 'NUM_T' 'DATE_T' 'CHAR_T' 'ROWID_T'
'RAW_T' 'NULL_T'
Lengths: 134 76 31 21 3 1
OraTypes: 2 12 1 104 23 1
SQLTypes: 8 9 12 -9104 -2 12
Scale: 0 0 0 0 0 0
Precision: 126 75 30 20 2 0
Nullable: 1 1 1 1 1 1
Est row width: 46
Data rows:
fetch: '7.2', '16-JUL-02', 'KEYSTONE', 'AAAACsAABAAAAS0AAA', '7D',
undef
csr reassigned (forces destruction)...
Fetch list of tables:
Fetched: FILE$
Fetched: BOOTSTRAP$
Fetched: SEG$
Fetched: ICOL$
Test ora_do with harmless non-select statement (set transaction read only)
Expect an 'ORA-01453' error message:
ora_do: 1453: ORA-01453: SET TRANSACTION must be first statement of
transaction (DBD ERROR: OCIStmtExecute)
csr out of scope...
ora_logoff...
lda out of scope...
Testing repetitive connect/open/close/disconnect:
If this test hangs then read the README.help file.
Expect sequence of digits, no other messages:
1 2 3 4 5
Test interaction of explicit close/logoff and implicit DESTROYs
Expect just 'done.', no other messages:
done.
Testing row cache (5).
Test completed in 0 seconds.
Test complete (2 seconds).
If the tests above have produced the 'expected' output then they have
passed.
****************************************** END Of build text
Any help would be greatly appreciated.
Thanks
Brett Clifford
Systems Administrator
IT Services
