Urgent help required : Issue with DBD:Oracle 1.20 installation

Urgent help required : Issue with DBD:Oracle 1.20 installation

am 03.04.2008 22:00:52 von dnasa

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....


root@e02k603 # 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/a uto/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.m k
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/a uto/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?)

root@e02k603 # 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'
root@e02k603 # 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'
root@e02k603 # 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'


root@e02k603 # 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.

root@e02k603 # 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

Re: Urgent help required : Issue with DBD:Oracle 1.20 installation

am 04.04.2008 14:40:22 von scoles

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....
>
>
> root@e02k603 # 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/a uto/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.m k
> 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/a uto/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?)
>
> root@e02k603 # 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'
> root@e02k603 # 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'
> root@e02k603 # 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'
>
>
> root@e02k603 # 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.
>
> root@e02k603 # 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
>
>

Re: Urgent help required : Issue with DBD:Oracle 1.20 installation

am 04.04.2008 21:07:26 von dnasa

Thanks a lot.

I was able to install DBD 1.12 .


Regards

Divyansh Nasa
Global Operations - Production Engineering Services
Computer Sciences Corporation India Pvt.Ltd.
C - 24, Sector 58, Noida 201301(U.P)
India
------------------------------------------------------------ ------------------

Telephone
India : +91-120-4705180 (Direct Number)
US : +1 302 781 1010 Extn. 5180
E-mail : dnasa@csc.com
------------------------------------------------------------ ------------------


Computer Sciences Corporation India Private Limited
Registered Office: Electronics Complex, Software Technology Park, Indore,
Madhya Pradesh, India
Registered in India No: 10-11210

------------------------------------------------------------ ------------------------------------------------------------ -------------------------------------------------

This is a PRIVATE message. If you are not the intended recipient, please
delete without copying and kindly advise us by e-mail of the mistake in
delivery.
NOTE: Regardless of content, this e-mail shall not operate to bind CSC to
any order or other contract unless pursuant to explicit written agreement
or government initiative expressly permitting the use of e-mail for such
purpose.
------------------------------------------------------------ ------------------------------------------------------------ -------------------------------------------------





John Scoles
om> To
Divyansh Nasa/GIS/CSC@CSC
04/04/2008 06:10 cc
PM dbi-users@perl.org
Subject
Re: Urgent help required : Issue
Please respond to with DBD:Oracle 1.20 installation
scoles@pythian.co
m








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....
>
>
> root@e02k603 # 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/a uto/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.m k
> 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/a uto/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?)
>
> root@e02k603 # 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'
> root@e02k603 # 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'
> root@e02k603 # 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'
>
>
> root@e02k603 # 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.
>
> root@e02k603 # 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
>
>