Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Perl - Newbie question

Re: Perl - Newbie question

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Thu, 08 Jun 2006 03:06:24 GMT
Message-Id: <pan.2006.06.08.03.06.22.433192@sbcglobal.net> 





On Wed, 07 Jun 2006 18:31:58 -0700, dbaplusplus wrote:



> Thanks. Does not like DBI and Oracle driver for DBI are part of Oracle

> install. I am using Oracle 9.2.0.5 on UNIX. I will hav eto download

> them from cpan.




If you are using Unix, there is probably a little utility on your system
called "cpan". It needs a little configuration, but it is priceless for 
downloading modules for CPAN. Here is an example session:



[root_at_medo ~]# cpan


CPAN: File::HomeDir loaded ok


 cpan shell -- CPAN exploration and modules installation (v1.87)
ReadLine support enabled



 cpan> make DBD::Oracle


CPAN: Storable loaded ok


Going to read /root/.cpan/Metadata


  Database was generated on Wed, 07 Jun 2006 22:27:35 GMT
Running make for module DBD::Oracle


Running make for P/PY/PYTHIAN/DBD-Oracle-1.17.tar.gz
CPAN: Digest::SHA loaded ok


CPAN: Module::Signature loaded ok


WARNING: This key is not certified with a trusted signature!
Primary key fingerprint: 2E66 557A B97C 19C7 91AF  8E20 328D A867 450F 89EC Signature for /root/.cpan/sources/authors/id/P/PY/PYTHIAN/CHECKSUMS ok
CPAN: Compress::Zlib loaded ok


Checksum for /root/.cpan/sources/authors/id/P/PY/PYTHIAN/DBD-Oracle-1.17.tar.gz ok

Scanning cache /root/.cpan/build for sizes
DBD-Oracle-1.17/
DBD-Oracle-1.17/README.java.txt
DBD-Oracle-1.17/t/
DBD-Oracle-1.17/t/55nested.t
DBD-Oracle-1.17/t/23wide_db.t
DBD-Oracle-1.17/t/10general.t
DBD-Oracle-1.17/t/22nchar_utf8.t
DBD-Oracle-1.17/t/40ph_type.t
DBD-Oracle-1.17/t/21nchar.t
DBD-Oracle-1.17/t/22nchar_al32utf8.t
DBD-Oracle-1.17/t/15nls.t
DBD-Oracle-1.17/t/60reauth.t
DBD-Oracle-1.17/t/25plsql.t
DBD-Oracle-1.17/t/23wide_db_8bit.t
DBD-Oracle-1.17/t/24implicit_utf8.t
DBD-Oracle-1.17/t/nchar_test_lib.pl
DBD-Oracle-1.17/t/50cursor.t
DBD-Oracle-1.17/t/23wide_db_al32utf8.t
DBD-Oracle-1.17/t/20select.t
DBD-Oracle-1.17/t/70meta.t
DBD-Oracle-1.17/t/31lob.t
DBD-Oracle-1.17/t/01base.t
DBD-Oracle-1.17/t/30long.t
DBD-Oracle-1.17/Oracle.ex/
DBD-Oracle-1.17/Oracle.ex/README
DBD-Oracle-1.17/Oracle.ex/sql
DBD-Oracle-1.17/Oracle.ex/bind.pl
DBD-Oracle-1.17/Oracle.ex/tabinfo.pl
DBD-Oracle-1.17/Oracle.ex/commit.pl
DBD-Oracle-1.17/Oracle.ex/ex.pl
DBD-Oracle-1.17/Oracle.ex/curref.pl
DBD-Oracle-1.17/Oracle.ex/japh
DBD-Oracle-1.17/Oracle.ex/proc.pl
DBD-Oracle-1.17/Oracle.ex/mktable.pl
DBD-Oracle-1.17/Oracle.ex/oradump.pl
DBD-Oracle-1.17/Changes
DBD-Oracle-1.17/Oracle.h
DBD-Oracle-1.17/MANIFEST
DBD-Oracle-1.17/typemap
DBD-Oracle-1.17/lib/
DBD-Oracle-1.17/lib/DBD/
DBD-Oracle-1.17/lib/DBD/Oracle/
DBD-Oracle-1.17/lib/DBD/Oracle/GetInfo.pm
DBD-Oracle-1.17/dbdimp.c
DBD-Oracle-1.17/README.hpux.txt
DBD-Oracle-1.17/README.login.txt
DBD-Oracle-1.17/README.linux.txt
DBD-Oracle-1.17/README.vms.txt
DBD-Oracle-1.17/hints/
DBD-Oracle-1.17/hints/macos_syms.pl
DBD-Oracle-1.17/hints/svr4.pl
DBD-Oracle-1.17/hints/macos_bundle.syms
DBD-Oracle-1.17/hints/dgux.pl
DBD-Oracle-1.17/hints/macos_lib.syms
DBD-Oracle-1.17/README.win32.txt
DBD-Oracle-1.17/oraperl.ph
DBD-Oracle-1.17/README.longs.txt
DBD-Oracle-1.17/README.macosx.txt
DBD-Oracle-1.17/test.pl
DBD-Oracle-1.17/oci.def
DBD-Oracle-1.17/Todo
DBD-Oracle-1.17/Oraperl.pm
DBD-Oracle-1.17/README.help.txt
DBD-Oracle-1.17/README.explain.txt
DBD-Oracle-1.17/README
DBD-Oracle-1.17/ora_explain.PL
DBD-Oracle-1.17/README.sec.txt
DBD-Oracle-1.17/oci8.c
DBD-Oracle-1.17/META.yml
DBD-Oracle-1.17/README.wingcc.txt
DBD-Oracle-1.17/dbdimp.h
DBD-Oracle-1.17/Oracle.xs
DBD-Oracle-1.17/ocitrace.h
DBD-Oracle-1.17/Oracle.pm
DBD-Oracle-1.17/dbivport.h
DBD-Oracle-1.17/README.clients.txt
DBD-Oracle-1.17/README.aix.txt
DBD-Oracle-1.17/Makefile.PL




Removing previously used /root/.cpan/build/DBD-Oracle-1.17
Package came without SIGNATURE




  CPAN.pm: Going to build P/PY/PYTHIAN/DBD-Oracle-1.17.tar.gz



Using DBI 1.50 (for perl 5.008006 on i386-linux-thread-multi) installed in /usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-multi/auto/DBI/



Configuring DBD::Oracle for perl 5.008006 on linux (i386-linux-thread-multi)



Remember to actually *READ* the README file! Especially if you have any problems.



Using Oracle in /oracle/product/10g


DEFINE _SQLPLUS_RELEASE = "1002000200" (CHAR)

Oracle version 10.2.0.2 (10.2)


Found /oracle/product/10g/rdbms/demo/demo_rdbms.mk
Using /oracle/product/10g/rdbms/demo/demo_rdbms.mk
Your LD_LIBRARY_PATH env var is set to ''
WARNING: Your LD_LIBRARY_PATH env var doesn't include '/oracle/product/10g/lib' but probably needs to.
Reading /oracle/product/10g/rdbms/demo/demo_rdbms.mk
Reading /oracle/product/10g/rdbms/lib/env_rdbms.mk



Attempting to discover Oracle OCI build rules
gcc    -c -o DBD_ORA_OBJ.o DBD_ORA_OBJ.c
by executing: [make -f /oracle/product/10g/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]
Oracle oci build command:


        [true -L/oracle/product/10g/lib/ -L/oracle/product/10g/rdbms/lib/ -o DBD_ORA_EXE DBD_ORA_OBJ.o -lclntsh   `cat /oracle/product/10g/lib/sysliblist` -ldl -lm  ]



Found header files in /oracle/product/10g/rdbms/public.



Checking for functioning wait.ph




System: perl5.008006 linux hs20-bc1-4.build.redhat.com 2.6.9-34.elsmp #1 smp fri feb 24 16:56:28 est 2006 i686 i686 i386 gnulinux
Compiler:   gcc -O2 -g -pipe -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -m32 -march=i386 -mtune=pentium4 -fasynchronous-unwind-tables -D_REENTRANT -D_GNU_SOURCE -DDEBUGGING -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm
Linker:     /usr/bin/ld


Sysliblist: -ldl -lm -lpthread -lnsl -lirc
Oracle makefiles would have used these definitions but we override them:
  CC:       $(COMPDIR)/bin/gcc


  CFLAGS:   $(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS) $(PFLAGS)\


        $(SHARED_CFLAG) $(USRFLAGS)
           [$(GFLAG) -O2 $(CDEBUG) $(CCFLAGS) -I/oracle/product/10g/rdbms/demo -I/oracle/product/10g/rdbms/public -I/oracle/product/10g/plsql/public -I/oracle/product/10g/network/public -DLINUX -D_GNU_SOURCE -D_LARGEFILE64_SOURCE=1 -D_LARGEFILE_SOURCE=1 -DSLTS_ENABLE -DSLMXMX_ENABLE -D_REENTRANT -DNS_THREADS $(LPFLAGS) $(USRFLAGS)]
  LDFLAGS:  -o $@ $(LDPATHFLAG)$(PRODLIBHOME) $(LDPATHFLAG)$(LIBHOME) $(LDPATHFLAG)$(LIBHOME)stubs/ -L$(COMPDIR)/lib -lirc
           [-o $@ -L/oracle/product/10g/rdbms/lib/ -L$(LIBHOME) -L$(LIBHOME)stubs/ -L/usr/lib -lirc]


Linking with OTHERLDFLAGS = -L/oracle/product/10g/lib/ -L/oracle/product/10g/rdbms/lib/   -lclntsh   `cat /oracle/product/10g/lib/sysliblist` -ldl -lm   [from 'build' rule]



Checking if your kit is complete...


Looks good


LD_RUN_PATH=/oracle/product/10g/lib:/oracle/product/10g/rdbms/lib
Using DBD::Oracle 1.17.


Using DBD::Oracle 1.17.


Using DBI 1.50 (for perl 5.008006 on i386-linux-thread-multi) installed in /usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-multi/auto/DBI/
Writing Makefile for DBD::Oracle






CPAN: YAML loaded ok


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
/usr/bin/perl -p -e "s/~DRIVER~/Oracle/g" /usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-multi/auto/DBI//Driver.xst > Oracle.xsi
/usr/bin/perl /usr/lib/perl5/5.8.6/ExtUtils/xsubpp  -typemap /usr/lib/perl5/5.8.6/ExtUtils/typemap -typemap typemap  Oracle.xs > Oracle.xsc && mv Oracle.xsc Oracle.c
gcc -c  -I/oracle/product/10g/rdbms/public -I/oracle/product/10g/rdbms/demo -I/oracle/product/10g/rdbms/public -I/oracle/product/10g/plsql/public -I/oracle/product/10g/network/public -I/usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-multi/auto/DBI/ -D_REENTRANT -D_GNU_SOURCE -DDEBUGGING -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -m32 -march=i386 -mtune=pentium4 -fasynchronous-unwind-tables   -DVERSION=\"1.17\" -DXS_VERSION=\"1.17\" -fPIC "-I/usr/lib/perl5/5.8.6/i386-linux-thread-multi/CORE"  -Wall -Wno-comment -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.2\" Oracle.c
Oracle.c: In function ‘XS_DBD__Oracle__db_ora_lob_append’:
Oracle.xs:201: warning: unused variable ‘startp’
gcc -c  -I/oracle/product/10g/rdbms/public -I/oracle/product/10g/rdbms/demo -I/oracle/product/10g/rdbms/public -I/oracle/product/10g/plsql/public -I/oracle/product/10g/network/public -I/usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-multi/auto/DBI/ -D_REENTRANT -D_GNU_SOURCE -DDEBUGGING -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -m32 -march=i386 -mtune=pentium4 -fasynchronous-unwind-tables   -DVERSION=\"1.17\" -DXS_VERSION=\"1.17\" -fPIC "-I/usr/lib/perl5/5.8.6/i386-linux-thread-multi/CORE"  -Wall -Wno-comment -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.2\" dbdimp.c
gcc -c  -I/oracle/product/10g/rdbms/public -I/oracle/product/10g/rdbms/demo -I/oracle/product/10g/rdbms/public -I/oracle/product/10g/plsql/public -I/oracle/product/10g/network/public -I/usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-multi/auto/DBI/ -D_REENTRANT -D_GNU_SOURCE -DDEBUGGING -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -m32 -march=i386 -mtune=pentium4 -fasynchronous-unwind-tables   -DVERSION=\"1.17\" -DXS_VERSION=\"1.17\" -fPIC "-I/usr/lib/perl5/5.8.6/i386-linux-thread-multi/CORE"  -Wall -Wno-comment -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"10.2.0.2\" oci8.c
oci8.c:563: warning: ‘fetch_func_nty’ defined but not used
Running Mkbootstrap for DBD::Oracle ()


chmod 644 Oracle.bs


rm -f blib/arch/auto/DBD/Oracle/Oracle.so
gcc  -shared -L/usr/local/lib Oracle.o dbdimp.o oci8.o -L/oracle/product/10g/lib/ -L/oracle/product/10g/rdbms/lib/   -lclntsh   `cat /oracle/product/10g/lib/sysliblist` -ldl -lm   -o blib/arch/auto/DBD/Oracle/Oracle.so
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/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/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/ora_explain

Manifying blib/man1/ora_explain.1
Manifying blib/man3/DBD::Oracle.3pm
Manifying blib/man3/DBD::Oraperl.3pm




  /usr/bin/make  -- OK



 cpan>



I could have installed it, but this module is already installed on my
system, so I don't really want that.


-- 
http://www.mgogala.com


Received on Wed Jun 07 2006 - 22:06:24 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US