[dartagnan:local/src/perlmodules] wayne# cd DBD-Oracle-1.22
[dartagnan:src/perlmodules/DBD-Oracle-1.22] wayne# make realclean
rm -f \
blib/script/ora_explain
rm -f \
*.a core \
core.[0-9] blib/arch/auto/DBD/Oracle/extralibs.all \
core.[0-9][0-9] Oracle.bso \
pm_to_blib.ts core.[0-9][0-9][0-9][0-9] \
Oracle.x Oracle.bs \
perl tmon.out \
*.o pm_to_blib \
blib/arch/auto/DBD/Oracle/extralibs.ld blibdirs.ts \
Oracle.c core.[0-9][0-9][0-9][0-9][0-9] \
*perl.core core.*perl.*.? \
Makefile.aperl perl \
Oracle.def core.[0-9][0-9][0-9] \
mon.out libOracle.def \
perlmain.c perl.exe \
so_locations Oracle.exp
rm -rf \
ora_explain dll.base \
DBD_ORA_OBJ.* Oracle.xsi \
dll.exp libOracle.def \
sqlnet.log blib \
mk.pm xstmp.c
mv Makefile Makefile.old > /dev/null 2>&1
rm -f \
DBD_ORA_OBJ.o Oracle.o dbdimp.o oci8.o Makefile.old \
Makefile
rm -rf \
DBD-Oracle-1.22
[dartagnan:src/perlmodules/DBD-Oracle-1.22] wayne# perl Makefile.PL
Using DBI 1.607 (for perl 5.008008 on darwin-thread-multi-2level)
installed in /Library/Perl/5.8.8/darwin-thread-multi-2level/auto/DBI/
Configuring DBD::Oracle for perl 5.008008 on darwin (darwin-thread-
multi-2level)
Remember to actually *READ* the README file! Especially if you have
any problems.
Installing on a darwin, Ver#9.0
Using Oracle in /Users/oracle/9iR2
DEFINE _SQLPLUS_RELEASE = "902000100" (CHAR)
Oracle version 9.2.0.1 (9.2)
Found /Users/oracle/9iR2/rdbms/demo/demo_rdbms.mk
Found /Users/oracle/9iR2/rdbms/lib/ins_rdbms.mk
Found /Users/oracle/9iR2/precomp/demo/proc/demo_proc.mk
Using /Users/oracle/9iR2/rdbms/demo/demo_rdbms.mk
Your DYLD_LIBRARY_PATH env var is set to '/Users/oracle/9iR2/lib'
Reading /Users/oracle/9iR2/rdbms/demo/demo_rdbms.mk
Reading /Users/oracle/9iR2/rdbms/lib/env_rdbms.mk
Attempting to discover Oracle OCI build rules
cc -c -o DBD_ORA_OBJ.o DBD_ORA_OBJ.c
by executing: [make -f /Users/oracle/9iR2/rdbms/demo/demo_rdbms.mk
build ECHODO=echo ECHO=echo GENCLNTSH='echo genclntsh' CC=true
OPTIMIZE= CCFLAGS= EXE=DBD_ORA_EXE OBJS=DBD_ORA_OBJ.o]
WARNING: Oracle build rule discovery failed (512)
Oracle oci build command:
[]
WARNING: Unable to interpret Oracle build commands from /Users/oracle/
9iR2/rdbms/demo/demo_rdbms.mk.
(Will continue by using fallback approach.)
Please report this to [EMAIL PROTECTED] See README for what to
include.
Found header files in /Users/oracle/9iR2/rdbms/public /Users/oracle/
9iR2/plsql/public /Users/oracle/9iR2/rdbms/demo.
Checking for functioning wait.ph
System: perl5.008008 darwin omen.apple.com 9.0 darwin kernel version
9.0.0b5: mon sep 10 17:17:11 pdt 2007; root:xnu-1166.6~1release_ppc
power macintosh
Compiler: cc -O3 -arch i386 -arch ppc -g -pipe -fno-common -
DPERL_DARWIN -no-cpp-precomp -fno-strict-aliasing -Wdeclaration-after-
statement -I/usr/local/include
Linker: /usr/bin/ld
Sysliblist: -ldl -lpoll -lm -lpthread
Oracle makefiles would have used these definitions but we override them:
CC: cc
CFLAGS: $(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS) $(PFLAGS)\
$(SHARED_CFLAG) $(USRFLAGS)
[$(GFLAG) -O3 $(CDEBUG) $(CCFLAGS) -I/Users/oracle/9iR2/
rdbms/demo -I/Users/oracle/9iR2/rdbms/public -I/Users/oracle/9iR2/
plsql/public -I/Users/oracle/9iR2/network/public -DMAC_OSX -
D_GNU_SOURCE -DSLTS_ENABLE -DSLMXMX_ENABLE -D_REENTRANT -DNS_THREADS $
(LPFLAGS) $(USRFLAGS)]
build: $(BUILDEXE32)
[ $(BUILDEXE32)]
LDFLAGS: -o $@ $(LDPATHFLAG)$(PRODLIBHOME) $(LDPATHFLAG)$(LIBHOME)
$(LDPATHFLAG)$(LIBHOME)stubs/
[-o $@ -L/Users/oracle/9iR2/rdbms/lib/ -L$(LIBHOME) -L$
(LIBHOME)stubs/]
Linking with /Users/oracle/9iR2/rdbms/lib/defopt.o -lclntsh -ldl -
lpoll -lm -lpthread -L/Users/oracle/9iR2/lib -lm [from $(DEF_OPT) $
(OCISHAREDLIBS)]
Checking if your kit is complete...
Warning: the following files are missing in your kit:
META.yml
Please inform the author.
LD_RUN_PATH=/Users/oracle/9iR2/lib
Using DBD::Oracle 1.22.
Using DBD::Oracle 1.22.
Using DBI 1.607 (for perl 5.008008 on darwin-thread-multi-2level)
installed in /Library/Perl/5.8.8/darwin-thread-multi-2level/auto/DBI/
Writing Makefile for DBD::Oracle
*** If you have problems...
read all the log printed above, and the README and
README.help.txt files.
(Of course, you have read README by now anyway, haven't you?)
[dartagnan:src/perlmodules/DBD-Oracle-1.22] wayne#
The demo_rdbms.mk file contains:
[dartagnan:cpan/build/DBD-Oracle-1.22-HWYkvM] wayne# cat /Users/oracle/
9iR2/rdbms/demo/demo_rdbms.mk
# This makefile is similar to demo_rdbms.mk, but this one builds
# 32-bit client executables. (It uses demo_rdbms.mk to build any
# shared-libraries that are loaded into the database server, e.g. for
# external procedure call.)
#
# Example for building demo OCI programs:
#
# 1. All OCI demos (including extdemo2, extdemo4 and extdemo5):
#
# make -f demo_rdbms32.mk demos
#
# 2. A single OCI demo:
#
# make -f demo_rdbms32.mk build EXE=demo OBJS="demo.o ..."
# e.g. make -f demo_rdbms32.mk build EXE=oci02 OBJS=oci02.o
#
# 3. A single OCI demo with static libraries:
#
# make -f demo_rdbms32.mk build_static EXE=demo OBJS="demo.o ..."
# e.g. make -f demo_rdbms32.mk build_static EXE=oci02 OBJS=oci02.o
#
# 4. To re-generate shared library:
#
# make -f demo_rdbms32.mk generate_sharedlib
#
# 5. All OCCI demos
#
# make -f demo_rdbms32.mk occidemos
#
# 6. A single OCCI demo:
#
# make -f demo_rdbms32.mk <demoname>
# e.g. make -f demo_rdbms32.mk occidml
# OR
# make -f demo_rdbms32.mk buildocci EXE=demoname
OBJS="demoname.o ..."
# e.g. make -f demo_rdbms32.mk buildocci EXE=occidml OBJS=occidml.o
#
# 7. A single OCCI demo with static libraries:
#
# make -f demo_rdbms32.mk buildocci_static EXE=demoname
OBJS="demoname.o ..."
# e.g. make -f demo_rdbms32.mk buildocci_static EXE=occiblob
OBJS=occiblob.o
#
# 8. All OCI Connection Pooling, Session Pooling and Statement Cache
demos
#
# make -f demo_rdbms32.mk cpdemos
#
# 9. A single OCI Connection Pooling demo:
#
# make -f demo_rdbms32.mk <demoname>
# e.g. make -f demo_rdbms32.mk cdemocp
# OR
# make -f demo_rdbms32.mk buildcp EXE=demoname OBJS="demoname.o ..."
# e.g. make -f demo_rdbms32.mk buildcp EXE=cdemocp OBJS=cdemocp.o
#
# 10. A single OCI Connection Pooling demo with static libraries:
#
# make -f demo_rdbms32.mk buildcp_static EXE=demoname
OBJS="demoname.o ..."
# e.g. make -f demo_rdbms32.mk buildcp_static EXE=cdemocp
OBJS=cdemocp.o
#
# 11. A single OCI Session Pooling demo:
#
# make -f demo_rdbms32.mk <demoname>
# e.g. make -f demo_rdbms32.mk cdemosp
# OR
# make -f demo_rdbms32.mk buildcp EXE=demoname OBJS="demoname.o ..."
# e.g. make -f demo_rdbms32.mk buildcp EXE=cdemosp OBJS=cdemosp.o
#
# 12. A single OCI Session Pooling demo with static libraries:
#
# make -f demo_rdbms32.mk buildcp_static EXE=demoname
OBJS="demoname.o ..."
# e.g. make -f demo_rdbms32.mk buildcp_static EXE=cdemosp
OBJS=cdemosp.o
#
#
# 13. A single OCI Statement Cache demo:
#
# make -f demo_rdbms32.mk <demoname>
# e.g. make -f demo_rdbms32.mk cdemostc
# OR
# make -f demo_rdbms32.mk buildcp EXE=demoname OBJS="demoname.o ..."
# e.g. make -f demo_rdbms32.mk buildcp EXE=cdemostc OBJS=cdemostc.o
#
# 14. A single OCI Statement Cache demo with static libraries:
#
# make -f demo_rdbms32.mk buildcp_static EXE=demoname
OBJS="demoname.o ..."
# e.g. make -f demo_rdbms32.mk buildcp_static EXE=cdemostc
OBJS=cdemostc.o
#
#
# Example for building demo DIRECT PATH API programs:
#
# 1. All DIRECT PATH API demos:
#
# make -f demo_rdbms32.mk demos_dp
#
# 2. A single DIRECT PATH API demo:
#
# make -f demo_rdbms32.mk build_dp EXE=demo OBJS="demo.o ..."
# e.g. make -f demo_rdbms32.mk build_dp EXE=cdemdplp OBJS=cdemdplp.o
#
#
# Example for building external procedures demo programs:
#
# 1. All external procedure demos:
#
# 2. A single external procedure demo whose 3GL routines do not use the
# "with context" argument:
#
# make -f demo_rdbms32.mk extproc_no_context SHARED_LIBNAME=libname
# OBJS="demo.o ..."
# e.g. make -f demo_rdbms32.mk extproc_no_context
SHARED_LIBNAME=epdemo.so
# OBJS="epdemo1.o epdemo2.o"
#
# 3. A single external procedure demo where one or more 3GL routines
use the
# "with context" argument:
#
# make -f demo_rdbms32.mk extproc_with_context SHARED_LIBNAME=libname
# OBJS="demo.o ..."
# e.g. make -f demo_rdbms32.mk extproc_with_context
SHARED_LIBNAME=epdemo.so
# OBJS="epdemo1.o epdemo2.o"
# e.g. make -f demo_rdbms32.mk extproc_with_context
# SHARED_LIBNAME=extdemo2.so OBJS="extdemo2.o"
# e.g. or For EXTDEMO2 DEMO ONLY: make -f demo_rdbms32.mk demos
#
# 4. To link C++ demos:
#
# make -f demo_rdbms32.mk c++demos
#
#
# NOTE: 1. ORACLE_HOME must be either:
# . set in the user's environment
# . passed in on the command line
# . defined in a modified version of this makefile
#
# 2. If the target platform support shared libraries (e.g.
Solaris)
# look in the platform specific documentation for information
# about environment variables that need to be properly
# defined (e.g. LD_LIBRARY_PATH in Solaris).
#
include $(ORACLE_HOME)/rdbms/lib/env_rdbms.mk
# flag for linking with non-deferred option (default is deferred mode)
NONDEFER=false
DEMO_DIR=$(ORACLE_HOME)/rdbms/demo
DEMO_MAKEFILE = $(DEMO_DIR)/demo_rdbms.mk
DEMO32_MAKEFILE = $(DEMO_DIR)/demo_rdbms32.mk
DEMOS = cdemo1 cdemo2 cdemo3 cdemo4 cdemo5 cdemo81 cdemo82 \
cdemobj cdemolb cdemodsc cdemocor cdemolb2 cdemolbs \
cdemodr1 cdemodr2 cdemodr3 cdemodsa obndra \
cdemoext cdemothr cdemofil cdemofor \
oci02 oci03 oci04 oci05 oci06 oci07 oci08 oci09 oci10 \
oci11 oci12 oci13 oci14 oci15 oci16 oci17 oci18 oci19 oci20 \
oci21 oci22 oci23 oci24 oci25 readpipe cdemosyev \
ociaqdemo00 ociaqdemo01 ociaqdemo02 cdemoucb nchdemo1
DEMOS_DP = cdemdpco cdemdpin cdemdpit cdemdplp cdemdpno cdemdpro
cdemdpss
C++DEMOS = cdemo6
OCCIDEMOS = occiblob occiclob occicoll occidesc occidml occipool
occiproc \
occistre
OCCIOTTDEMOS = occiobj occiinh occipobj
# OTT Markers Support
OCCIOTTDEMOSWITHMARKER = mdemo1
OTTUSR = scott
OTTPWD = tiger
CPDEMOS = cdemocp cdemocpproxy cdemosp cdemostc
.SUFFIXES: .o .cob .for .c .pc .cc .cpp
demos: $(DEMOS) extdemo2 extdemo4 extdemo5
demos_dp: $(DEMOS_DP)
generate_sharedlib:
$(SILENT)$(ECHO) "Building client shared library ..."
$(SILENT)$(ECHO) "Calling script $$ORACLE_HOME/bin/genclntsh ..."
$(GENCLNTSH32)
$(SILENT)$(ECHO) "The library is $$ORACLE_HOME/lib/libclntsh.so...
DONE"
BUILD=build
$(DEMOS):
$(MAKE) -f $(DEMO32_MAKEFILE) $(BUILD) EXE=$@ [EMAIL PROTECTED]
$(DEMOS_DP): cdemodp.c cdemodp0.h cdemodp.h
$(MAKE) -f $(DEMO32_MAKEFILE) build_dp EXE=$@ [EMAIL PROTECTED]
c++demos: $(C++DEMOS)
$(C++DEMOS):
$(MAKE) -f $(DEMO32_MAKEFILE) buildc++ EXE=$@ [EMAIL PROTECTED]
buildc++: $(OBJS)
$(MAKECPLPLDEMO32)
occidemos: $(OCCIDEMOS) $(OCCIOTTDEMOS) $(OCCIOTTDEMOSWITHMARKER)
$(OCCIDEMOS):
$(MAKE) -f $(DEMO32_MAKEFILE) buildocci EXE=$@ [EMAIL PROTECTED]
$(OCCIOTTDEMOS):
$(MAKE) -f $(DEMO32_MAKEFILE) ott OTTFILE=$@
$(MAKE) -f $(DEMO32_MAKEFILE) buildocci EXE=$@ OBJS="[EMAIL PROTECTED]
[EMAIL PROTECTED] [EMAIL PROTECTED]"
# OTT Markers Support
$(OCCIOTTDEMOSWITHMARKER):
$(MAKE) -f $(DEMO_MAKEFILE) ott_mrkr OTTFILE=$@
$(MAKE) -f $(DEMO_MAKEFILE) buildocci EXE=$@ OBJS="[EMAIL PROTECTED] [EMAIL
PROTECTED] [EMAIL PROTECTED]"
buildocci: $(OBJS)
$(MAKEOCCISHAREDDEMO32)
buildocci_static: $(OBJS)
$(MAKEOCCISTATICDEMO32)
ott:
$(ORACLE_HOME)/bin/ott \
userid=$(OTTUSR)/$(OTTPWD) \
intype=$(OTTFILE).typ \
outtype=$(OTTFILE)out.type \
code=cpp \
hfile=$(OTTFILE).h \
cppfile=$(OTTFILE)o.cpp \
attraccess=private
# OTT Markers Suppport
ott_mrkr:
$(ORACLE_HOME)/bin/ott \
userid=$(OTTUSR)/$(OTTPWD) \
intype=$(OTTFILE).typ \
outtype=$(OTTFILE)out.type \
code=cpp \
hfile=$(OTTFILE).h \
cppfile=$(OTTFILE)o.cpp \
use_marker=true
cpdemos: $(CPDEMOS)
$(CPDEMOS):
$(MAKE) -f $(DEMO32_MAKEFILE) buildcp EXE=$@ [EMAIL PROTECTED]
buildcp: $(OBJS)
$(MAKECPSHAREDDEMO32)
buildcp_static: $(OBJS)
$(MAKECPSTATICDEMO32)
# Pro*C rules
# SQL Precompiler macros
pc1:
$(PCC2C)
.pc.c:
$(MAKE) -f $(DEMO32_MAKEFILE) PCCSRC=$* I_SYM=include= pc1
.pc.o:
$(MAKE) -f $(DEMO32_MAKEFILE) PCCSRC=$* I_SYM=include= pc1
$(PCCC2O32)
.cc.o:
$(CCC2O32)
.cpp.o:
$(CCC2O32)
build: $(LIBCLNTSH) $(OBJS)
$(BUILDEXE32)
extdemo2:
$(MAKE) -f $(DEMO_MAKEFILE) extproc_with_context
SHARED_LIBNAME=extdemo2.so OBJS="extdemo2.o"
extdemo4:
$(MAKE) -f $(DEMO_MAKEFILE) extproc_with_context
SHARED_LIBNAME=extdemo4.so OBJS="extdemo4.o"
extdemo5:
$(MAKE) -f $(DEMO_MAKEFILE) extproc_with_context
SHARED_LIBNAME=extdemo5.so OBJS="extdemo5.o"
.c.o:
$(C2O32)
build_dp: $(LIBCLNTSH) $(OBJS) cdemodp.o
$(DPTARGET32)
build_static: $(OBJS)
$(O2STATIC32)
# extproc_no_context and extproc_with_context are the current names of
these
# targets. The old names, extproc_nocallback and extproc_callback are
# preserved for backward compatibility.
extproc_no_context extproc_nocallback: $(OBJS)
$(BUILDLIB_NO_CONTEXT)
extproc_with_context extproc_callback: $(OBJS) $(LIBCLNTSH)
$(BUILDLIB_WITH_CONTEXT)
clean:
$(RM) -f $(DEMOS) $(CPDEMOS) extdemo2 extdemo4 extdemo5 *.o *.so
$(RM) -f $(OCCIDEMOS) $(OCCIOTTDEMOS) $(OCCIOTTDEMOSWITHMARKER)
occi*m.cpp occi*o.cpp \
occi*.type occiobj*.h occiinh*.h occipobj*.h
$(RM) -f $(DEMOS_DP)
[dartagnan:cpan/build/DBD-Oracle-1.22-HWYkvM] wayne#
make output:
[dartagnan:src/perlmodules/DBD-Oracle-1.22] wayne# make
cp Oracle.pm blib/lib/DBD/Oracle.pm
cp oraperl.ph blib/lib/oraperl.ph
cp dbdimp.h blib/arch/auto/DBD/Oracle/dbdimp.h
cp ocitrace.h blib/arch/auto/DBD/Oracle/ocitrace.h
cp Oraperl.pm blib/lib/Oraperl.pm
cp Oracle.h blib/arch/auto/DBD/Oracle/Oracle.h
cp lib/DBD/Oracle/GetInfo.pm blib/lib/DBD/Oracle/GetInfo.pm
cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm
cc -c -I/Users/oracle/9iR2/rdbms/public -I/Users/oracle/9iR2/plsql/
public -I/Users/oracle/9iR2/rdbms/demo -I/Users/oracle/9iR2/rdbms/demo
-I/Users/oracle/9iR2/rdbms/public -I/Users/oracle/9iR2/plsql/public -I/
Users/oracle/9iR2/network/public -I/Library/Perl/5.8.8/darwin-thread-
multi-2level/auto/DBI -arch i386 -arch ppc -g -pipe -fno-common -
DPERL_DARWIN -no-cpp-precomp -fno-strict-aliasing -Wdeclaration-after-
statement -I/usr/local/include -O3 -DVERSION=\"1.22\" -DXS_VERSION=
\"1.22\" "-I/System/Library/Perl/5.8.8/darwin-thread-multi-2level/
CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DNEW_OCI_INIT -
DORA_OCI_VERSION=\"9.2.0.1\" DBD_ORA_OBJ.c
/usr/bin/perl -p -e "s/~DRIVER~/Oracle/g" /Library/Perl/5.8.8/darwin-
thread-multi-2level/auto/DBI/Driver.xst > Oracle.xsi
/usr/bin/perl /System/Library/Perl/5.8.8/ExtUtils/xsubpp -typemap /
System/Library/Perl/5.8.8/ExtUtils/typemap -typemap typemap Oracle.xs
> Oracle.xsc && mv Oracle.xsc Oracle.c
cc -c -I/Users/oracle/9iR2/rdbms/public -I/Users/oracle/9iR2/plsql/
public -I/Users/oracle/9iR2/rdbms/demo -I/Users/oracle/9iR2/rdbms/demo
-I/Users/oracle/9iR2/rdbms/public -I/Users/oracle/9iR2/plsql/public -I/
Users/oracle/9iR2/network/public -I/Library/Perl/5.8.8/darwin-thread-
multi-2level/auto/DBI -arch i386 -arch ppc -g -pipe -fno-common -
DPERL_DARWIN -no-cpp-precomp -fno-strict-aliasing -Wdeclaration-after-
statement -I/usr/local/include -O3 -DVERSION=\"1.22\" -DXS_VERSION=
\"1.22\" "-I/System/Library/Perl/5.8.8/darwin-thread-multi-2level/
CORE" -Wall -Wno-comment -DUTF8_SUPPORT -DNEW_OCI_INIT -
DORA_OCI_VERSION=\"9.2.0.1\" Oracle.c
In file included from Oracle.xs:1:
Oracle.h:114: error: conflicting types for 'OCIXMLTypeCreateFromSrc'
Oracle.h:114: note: an argument type that has a default promotion
can't match an empty parameter name list declaration
/Users/oracle/9iR2/rdbms/demo/ociap.h:10038: error: previous
declaration of 'OCIXMLTypeCreateFromSrc' was here
In file included from Oracle.xs:1:
Oracle.h:114: error: conflicting types for 'OCIXMLTypeCreateFromSrc'
Oracle.h:114: note: an argument type that has a default promotion
can't match an empty parameter name list declaration
/Users/oracle/9iR2/rdbms/demo/ociap.h:10038: error: previous
declaration of 'OCIXMLTypeCreateFromSrc' was here
lipo: can't open input file: /var/tmp//ccZRY5dq.out (No such file or
directory)
make: *** [Oracle.o] Error 1
[dartagnan:src/perlmodules/DBD-Oracle-1.22] wayne#
