Well you oracle clients it ancient for one this (8.0.6.0 ) and
unfortunately installing DBD::Oracle on a sun box has always been
problematic.
the
dbdimp.c:2997: error: `OCI_BATCH_ERRORS' undeclared (first use in this
error basically tells me that you are missing this constant in the
'oci.h' of the client you are attempting to use. If this is the case
you will have to use an older version of DBD::ORACLE (1.17) if you want
to keep this client. I doesn't matter really as with this client you
cannot use any of the functionality of the later versions.
So if you must use the old oracle client use an older DBD::Oracle.
You can also compile you DBD:Oracle against the Oracle instant client
and it will work as well
cheers
John Scoles
Divyansh Nasa wrote:
Hi all
I am trying to install DBD-Oracle-1.20 downloaded from CPAN.
I am getting the following errors. Request you to help asap....
[EMAIL PROTECTED] # perl Makefile.PL
Using DBI 1.601 (for perl 5.008007 on sun4-solaris) installed in
/opt/soe/local/perl-5.8.7/lib/site_perl/5.8.7/sun4-solaris/auto/DBI/
Configuring DBD::Oracle for perl 5.008007 on solaris (sun4-solaris)
Remember to actually *READ* the README file! Especially if you have any
problems.
Using Oracle in /u02/app/dvoa061a/oracle/8.0.6
DEFINE _SQLPLUS_RELEASE = "800060000" (CHAR)
Oracle version 8.0.6.0 (8.0)
Found /u02/app/dvoa061a/oracle/8.0.6/rdbms/demo/demo_rdbms.mk
Found /u02/app/dvoa061a/oracle/8.0.6/precomp/demo/proc/demo_proc.mk
Using /u02/app/dvoa061a/oracle/8.0.6/rdbms/demo/demo_rdbms.mk
Your LD_LIBRARY_PATH env var is set to
'/usr/openwin/lib:/u02/app/dvoa061a/oracle/8.0.6/lib'
Reading /u02/app/dvoa061a/oracle/8.0.6/rdbms/demo/demo_rdbms.mk
Reading /u02/app/dvoa061a/oracle/8.0.6/rdbms/lib/env_rdbms.mk
Attempting to discover Oracle OCI build rules
gcc -c -I/u02/app/dvoa061a/oracle/8.0.6/rdbms/demo
-I/u02/app/dvoa061a/oracle/8.0.6/rdbms/demo
-I/u02/app/dvoa061a/oracle/8.0.6/rdbms/public
-I/u02/app/dvoa061a/oracle/8.0.6/plsql/public
-I/u02/app/dvoa061a/oracle/8.0.6/network/public -I/opt/soe/local/perl-5.8.7
/lib/site_perl/5.8.7/sun4-solaris/auto/DBI -fno-strict-aliasing -pipe
-I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O
-DVERSION=\"1.20\" -DXS_VERSION=\"1.20\" -fPIC
"-I/opt/soe/local/perl-5.8.7/lib/5.8.7/sun4-solaris/CORE" -Wall
-Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"8.0.6.0\"
-DUSE_ORA_OCI_STMNT_FETCH DBD_ORA_OBJ.c
by executing: [make -f /u02/app/dvoa061a/oracle/8.0.6
/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/u02/app/dvoa061a/oracle/8.0.6/lib/
-L/u02/app/dvoa061a/oracle/8.0.6/rdbms/lib -o DBD_ORA_EXE DBD_ORA_OBJ.o
-lclntsh /u02/app/dvoa061a/oracle/8.0.6/lib/nautab.o
/u02/app/dvoa061a/oracle/8.0.6/lib/naeet.o /u02/app/dvoa061a/oracle/8.0.6
/lib/naect.o /u02/app/dvoa061a/oracle/8.0.6/lib/naedhs.o -lnetv2 -lnttcp
-lnetwork -lncr -lnetv2 -lnttcp -lnetwork -lclient -lvsn -lcommon -lgeneric
-lmm -lnlsrtl3 -lcore4 -lnlsrtl3 -lcore4 -lnlsrtl3 -lnetv2 -lnttcp
-lnetwork -lncr -lnetv2 -lnttcp -lnetwork -lclient -lvsn -lcommon -lgeneric
-lepc -lnlsrtl3 -lcore4 -lnlsrtl3 -lcore4 -lnlsrtl3 -lclient -lvsn -lcommon
-lgeneric -lnlsrtl3 -lcore4 -lnlsrtl3 -lcore4 -lnlsrtl3 -lnsl -lsocket
-lgen -ldl -lc -laio -lm -lthread]
Found header files in /u02/app/dvoa061a/oracle/8.0.6/rdbms/demo.
Checking for functioning wait.ph
System: perl5.008007 sunos zlggs002 5.8 generic_108528-07 sun4u sparc
sunw,ultra-250
Compiler: gcc -O -fno-strict-aliasing -pipe -I/usr/local/include
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64
Linker: /usr/ccs/bin/ld
Sysliblist: -lnsl -lsocket -lgen -ldl
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=ultra -D_REENTRANT -K PIC
$(QACCFLAGS) -I/u02/app/dvoa061a/oracle/8.0.6/rdbms/demo
-I/u02/app/dvoa061a/oracle/8.0.6/rdbms/public
-I/u02/app/dvoa061a/oracle/8.0.6/plsql/public
-I/u02/app/dvoa061a/oracle/8.0.6/network/public -DSLMXMX_ENABLE
-DSLTS_ENABLE $(LPFLAGS) $(USRFLAGS)]
LDFLAGS: -L$(LIBHOME) -L$(ORACLE_HOME)/rdbms/lib
[-L$(LIBHOME) -L/u02/app/dvoa061a/oracle/8.0.6/rdbms/lib]
Linking with OTHERLDFLAGS = -L/u02/app/dvoa061a/oracle/8.0.6/lib/
-L/u02/app/dvoa061a/oracle/8.0.6/rdbms/lib -lclntsh
/u02/app/dvoa061a/oracle/8.0.6/lib/nautab.o /u02/app/dvoa061a/oracle/8.0.6
/lib/naeet.o /u02/app/dvoa061a/oracle/8.0.6/lib/naect.o
/u02/app/dvoa061a/oracle/8.0.6/lib/naedhs.o -lnetv2 -lnttcp -lnetwork -lncr
-lnetv2 -lnttcp -lnetwork -lclient -lvsn -lcommon -lgeneric -lmm -lnlsrtl3
-lcore4 -lnlsrtl3 -lcore4 -lnlsrtl3 -lnetv2 -lnttcp -lnetwork -lncr -lnetv2
-lnttcp -lnetwork -lclient -lvsn -lcommon -lgeneric -lepc -lnlsrtl3 -lcore4
-lnlsrtl3 -lcore4 -lnlsrtl3 -lclient -lvsn -lcommon -lgeneric -lnlsrtl3
-lcore4 -lnlsrtl3 -lcore4 -lnlsrtl3 -lnsl -lsocket -lgen -ldl -lc -laio -lm
-lthread [from 'build' rule]
WARNING: If you have problems you may need to rebuild perl with threading
enabled.
LD_RUN_PATH=/u02/app/dvoa061a/oracle/8.0.6
/lib:/u02/app/dvoa061a/oracle/8.0.6/rdbms/lib
Using DBD::Oracle 1.20.
Using DBD::Oracle 1.20.
Using DBI 1.601 (for perl 5.008007 on sun4-solaris) installed in
/opt/soe/local/perl-5.8.7/lib/site_perl/5.8.7/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.txt
files.
(Of course, you have read README by now anyway, haven't you?)
[EMAIL PROTECTED] # make
Skip blib/lib/DBD/Oracle.pm (unchanged)
Skip blib/lib/DBD/mkta.pl (unchanged)
Skip blib/lib/oraperl.ph (unchanged)
Skip blib/arch/auto/DBD/Oracle/dbdimp.h (unchanged)
Skip blib/arch/auto/DBD/Oracle/ocitrace.h (unchanged)
Skip blib/lib/Oraperl.pm (unchanged)
Skip blib/arch/auto/DBD/Oracle/Oracle.h (unchanged)
cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm
Skip blib/lib/DBD/Oracle/GetInfo.pm (unchanged)
gcc -c -I/u02/app/dvoa061a/oracle/8.0.6/rdbms/demo
-I/u02/app/dvoa061a/oracle/8.0.6/rdbms/demo
-I/u02/app/dvoa061a/oracle/8.0.6/rdbms/public
-I/u02/app/dvoa061a/oracle/8.0.6/plsql/public
-I/u02/app/dvoa061a/oracle/8.0.6/network/public -I/opt/soe/local/perl-5.8.7
/lib/site_perl/5.8.7/sun4-solaris/auto/DBI -fno-strict-aliasing -pipe
-I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O
-DVERSION=\"1.20\" -DXS_VERSION=\"1.20\" -fPIC
"-I/opt/soe/local/perl-5.8.7/lib/5.8.7/sun4-solaris/CORE" -Wall
-Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"8.0.6.0\"
-DUSE_ORA_OCI_STMNT_FETCH Oracle.c
gcc -c -I/u02/app/dvoa061a/oracle/8.0.6/rdbms/demo
-I/u02/app/dvoa061a/oracle/8.0.6/rdbms/demo
-I/u02/app/dvoa061a/oracle/8.0.6/rdbms/public
-I/u02/app/dvoa061a/oracle/8.0.6/plsql/public
-I/u02/app/dvoa061a/oracle/8.0.6/network/public -I/opt/soe/local/perl-5.8.7
/lib/site_perl/5.8.7/sun4-solaris/auto/DBI -fno-strict-aliasing -pipe
-I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O
-DVERSION=\"1.20\" -DXS_VERSION=\"1.20\" -fPIC
"-I/opt/soe/local/perl-5.8.7/lib/5.8.7/sun4-solaris/CORE" -Wall
-Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"8.0.6.0\"
-DUSE_ORA_OCI_STMNT_FETCH dbdimp.c
dbdimp.c: In function `ora_db_login6':
dbdimp.c:470: warning: unused variable `rsize'
dbdimp.c:337: warning: unused variable `new_charsetid'
dbdimp.c:338: warning: unused variable `new_ncharsetid'
dbdimp.c: In function `ora_st_execute_array':
dbdimp.c:2997: error: `OCI_BATCH_ERRORS' undeclared (first use in this
function)
dbdimp.c:2997: error: (Each undeclared identifier is reported only once
dbdimp.c:2997: error: for each function it appears in.)
dbdimp.c:3010: error: `OCI_ATTR_NUM_DML_ERRORS' undeclared (first use in
this function)
dbdimp.c:3029: error: `OCI_ATTR_DML_ROW_OFFSET' undeclared (first use in
this function)
*** Error code 1
make: Fatal error: Command failed for target `dbdimp.o'
[EMAIL PROTECTED] # make test
gcc -c -I/u02/app/dvoa061a/oracle/8.0.6/rdbms/demo
-I/u02/app/dvoa061a/oracle/8.0.6/rdbms/demo
-I/u02/app/dvoa061a/oracle/8.0.6/rdbms/public
-I/u02/app/dvoa061a/oracle/8.0.6/plsql/public
-I/u02/app/dvoa061a/oracle/8.0.6/network/public -I/opt/soe/local/perl-5.8.7
/lib/site_perl/5.8.7/sun4-solaris/auto/DBI -fno-strict-aliasing -pipe
-I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O
-DVERSION=\"1.20\" -DXS_VERSION=\"1.20\" -fPIC
"-I/opt/soe/local/perl-5.8.7/lib/5.8.7/sun4-solaris/CORE" -Wall
-Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"8.0.6.0\"
-DUSE_ORA_OCI_STMNT_FETCH dbdimp.c
dbdimp.c: In function `ora_db_login6':
dbdimp.c:470: warning: unused variable `rsize'
dbdimp.c:337: warning: unused variable `new_charsetid'
dbdimp.c:338: warning: unused variable `new_ncharsetid'
dbdimp.c: In function `ora_st_execute_array':
dbdimp.c:2997: error: `OCI_BATCH_ERRORS' undeclared (first use in this
function)
dbdimp.c:2997: error: (Each undeclared identifier is reported only once
dbdimp.c:2997: error: for each function it appears in.)
dbdimp.c:3010: error: `OCI_ATTR_NUM_DML_ERRORS' undeclared (first use in
this function)
dbdimp.c:3029: error: `OCI_ATTR_DML_ROW_OFFSET' undeclared (first use in
this function)
*** Error code 1
make: Fatal error: Command failed for target `dbdimp.o'
[EMAIL PROTECTED] # make install
gcc -c -I/u02/app/dvoa061a/oracle/8.0.6/rdbms/demo
-I/u02/app/dvoa061a/oracle/8.0.6/rdbms/demo
-I/u02/app/dvoa061a/oracle/8.0.6/rdbms/public
-I/u02/app/dvoa061a/oracle/8.0.6/plsql/public
-I/u02/app/dvoa061a/oracle/8.0.6/network/public -I/opt/soe/local/perl-5.8.7
/lib/site_perl/5.8.7/sun4-solaris/auto/DBI -fno-strict-aliasing -pipe
-I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O
-DVERSION=\"1.20\" -DXS_VERSION=\"1.20\" -fPIC
"-I/opt/soe/local/perl-5.8.7/lib/5.8.7/sun4-solaris/CORE" -Wall
-Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"8.0.6.0\"
-DUSE_ORA_OCI_STMNT_FETCH dbdimp.c
dbdimp.c: In function `ora_db_login6':
dbdimp.c:470: warning: unused variable `rsize'
dbdimp.c:337: warning: unused variable `new_charsetid'
dbdimp.c:338: warning: unused variable `new_ncharsetid'
dbdimp.c: In function `ora_st_execute_array':
dbdimp.c:2997: error: `OCI_BATCH_ERRORS' undeclared (first use in this
function)
dbdimp.c:2997: error: (Each undeclared identifier is reported only once
dbdimp.c:2997: error: for each function it appears in.)
dbdimp.c:3010: error: `OCI_ATTR_NUM_DML_ERRORS' undeclared (first use in
this function)
dbdimp.c:3029: error: `OCI_ATTR_DML_ROW_OFFSET' undeclared (first use in
this function)
*** Error code 1
make: Fatal error: Command failed for target `dbdimp.o'
[EMAIL PROTECTED] # perl -v
This is perl, v5.8.7 built for sun4-solaris
Copyright 1987-2005, Larry Wall
Perl may be copied only under the terms of either the Artistic License or
the
GNU General Public License, which may be found in the Perl 5 source kit.
Complete documentation for Perl, including FAQ lists, should be found on
this system using `man perl' or `perldoc perl'. If you have access to the
Internet, point your browser at http://www.perl.org/, the Perl Home Page.
[EMAIL PROTECTED] # gcc -v
Reading specs from /usr/local/lib/gcc/sparc-sun-solaris2.10/3.4.6/specs
Configured with: ../configure --with-as=/usr/ccs/bin/as
--with-ld=/usr/ccs/bin/ld --enable-shared --enable-languages=c,c++,f77
Thread model: posix
gcc version 3.4.6
Regards
Divyansh Nasa
