Thatis a very old version of Oracle client that you are trying to compile
against.
You might have to go back all the way to DDB14 which diso not have
SQLT_TIMESTAMP_LTZ in the code.
or get the Oracle instant clients and compile and connect with that one.
What was the old version of DBD::Oracle that you were using before?
cheers
John Scoles
----- Original Message -----
From: "Joe Torres" <[EMAIL PROTECTED]>
To: <dbi-users@perl.org>
Sent: Saturday, April 07, 2007 10:38 AM
Subject: DBD-Oracle-1.19 will not make nice
Hi All,
I am newbie using perl and perl modules, I need your assistance in getting
DBD-Oracle-1.19 installed. My system is a sun 280r, running solaris 8,
perl
v5.8.8 built for sun4-solaris-thread-multi, the error occurs when doing
make. TIA
perl Makefile.PL
Using DBI 1.54 (for perl 5.008008 on sun4-solaris-thread-multi) installed
in
/usr/local/lib/perl5/site_perl/5.8.8/sun4-solaris-thread-multi/auto/DBI/
Configuring DBD::Oracle for perl 5.008008 on solaris
(sun4-solaris-thread-multi)
Remember to actually *READ* the README file! Especially if you have any
problems.
Using Oracle in /home/oracle/OraHome1
DEFINE _SQLPLUS_RELEASE = "801070000" (CHAR)
Oracle version 8.1.7.0 (8.1)
Found /home/oracle/OraHome1/rdbms/demo/demo_rdbms.mk
Using /home/oracle/OraHome1/rdbms/demo/demo_rdbms.mk
Your LD_LIBRARY_PATH env var is set to
'/usr/local/lib:/usr/local/perl5/lib:/home/oracle/OraHome1/lib:/lib::/home/o
racle/OraHome1/rdbms/lib/'
Reading /home/oracle/OraHome1/rdbms/demo/demo_rdbms.mk
Reading /home/oracle/OraHome1/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 /home/oracle/OraHome1/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/home/oracle/OraHome1/lib/ -L/home/oracle/OraHome1/rdbms/lib
-o DBD_ORA_EXE DBD_ORA_OBJ.o -lclntsh
/home/oracle/OraHome1/rdbms/lib/kpuadef.o -lnbeq8 -lnhost8 -lnus8 -lnldap8
-lldapclnt8 -lnsslb8 -ln8 -lncrypt8 -ln8 -lncrypt8 -lnoname8 -lntcp8
-lntcps8 -lnsslb8 -lnent8 -lntcp8 -lntns8 -lnsgr8 -lnzjs8 -ln8 -lnl8 -lnro8
-lnbeq8 -lnhost8 -lnus8 -lnldap8 -lldapclnt8 -lnsslb8 -ln8 -lncrypt8 -ln8
-lncrypt8 -lnoname8 -lntcp8 -lntcps8 -lnsslb8 -lnent8 -lntcp8 -lntns8
-lnsgr8 -lnzjs8 -ln8 -lnl8 -lclient8 -lvsn8 -lwtc8 -lcommon8 -lgeneric8
-lwtc8 -lmm -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 -lnbeq8 -lnhost8 -lnus8
-lnldap8 -lldapclnt8 -lnsslb8 -ln8 -lncrypt8 -ln8 -lncrypt8 -lnoname8
-lntcp8 -lntcps8 -lnsslb8 -lnent8 -lntcp8 -lntns8 -lnsgr8 -lnzjs8 -ln8 -lnl8
-lnro8 -lnbeq8 -lnhost8 -lnus8 -lnldap8 -lldapclnt8 -lnsslb8 -ln8 -lncrypt8
-ln8 -lncrypt8 -lnoname8 -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 -lgeneric8 -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 -lnsl -lsocket
-lgen -ldl -lsched -lsched -R/home/oracle/OraHome1/lib -laio -lposix4
-lkstat -lm -lthread]
Found header files in /home/oracle/OraHome1/rdbms/demo.
Checking for functioning wait.ph
System: perl5.008008 sunos 5.8 generic_108528-17 sun4u sparc
sunw,sun-fire-280r
Compiler: gcc -O -D_REENTRANT -fno-strict-aliasing -pipe
-Wdeclaration-after-statement -I/usr/local/include -I/opt/local/include
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64
Linker: /usr/local/gnu/bin/ld
Sysliblist: -lnsl -lsocket -lgen -ldl -lsched
Oracle makefiles would have used these definitions but we override them:
CC: /opt/SUNWspro4.2/SUNWspro/bin/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/home/oracle/OraHome1/rdbms/demo
-I/home/oracle/OraHome1/rdbms/public -I/home/oracle/OraHome1/plsql/public
-I/home/oracle/OraHome1/network/public -DSLMXMX_ENABLE -DSLTS_ENABLE
-D_SVID_GETTOD $(LPFLAGS) $(USRFLAGS)]
LDFLAGS: -L$(LIBHOME) -L$(ORACLE_HOME)/rdbms/lib
[-L$(LIBHOME) -L/home/oracle/OraHome1/rdbms/lib]
Linking with OTHERLDFLAGS = -L/home/oracle/OraHome1/lib/
-L/home/oracle/OraHome1/rdbms/lib -lclntsh
/home/oracle/OraHome1/rdbms/lib/kpuadef.o -lnbeq8 -lnhost8 -lnus8 -lnldap8
-lldapclnt8 -lnsslb8 -ln8 -lncrypt8 -ln8 -lncrypt8 -lnoname8 -lntcp8
-lntcps8 -lnsslb8 -lnent8 -lntcp8 -lntns8 -lnsgr8 -lnzjs8 -ln8 -lnl8 -lnro8
-lnbeq8 -lnhost8 -lnus8 -lnldap8 -lldapclnt8 -lnsslb8 -ln8 -lncrypt8 -ln8
-lncrypt8 -lnoname8 -lntcp8 -lntcps8 -lnsslb8 -lnent8 -lntcp8 -lntns8
-lnsgr8 -lnzjs8 -ln8 -lnl8 -lclient8 -lvsn8 -lwtc8 -lcommon8 -lgeneric8
-lwtc8 -lmm -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 -lnbeq8 -lnhost8 -lnus8
-lnldap8 -lldapclnt8 -lnsslb8 -ln8 -lncrypt8 -ln8 -lncrypt8 -lnoname8
-lntcp8 -lntcps8 -lnsslb8 -lnent8 -lntcp8 -lntns8 -lnsgr8 -lnzjs8 -ln8 -lnl8
-lnro8 -lnbeq8 -lnhost8 -lnus8 -lnldap8 -lldapclnt8 -lnsslb8 -ln8 -lncrypt8
-ln8 -lncrypt8 -lnoname8 -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 -lgeneric8 -lnls8 -lcore8 -lnls8 -lcore8 -lnls8 -lnsl -lsocket
-lgen -ldl -lsched -lsched -R/home/oracle/OraHome1/lib -laio -lposix4
-lkstat -lm -lthread [from 'build' rule]
Checking if your kit is complete...
Looks good
Ignoring
LD_RUN_PATH='/home/oracle/OraHome1/rdbms/lib:/home/oracle/OraHome1/lib:'
in
environment
LD_RUN_PATH=/home/oracle/OraHome1/lib:/home/oracle/OraHome1/rdbms/lib
Using DBD::Oracle 1.19.
Using DBD::Oracle 1.19.
Using DBI 1.54 (for perl 5.008008 on sun4-solaris-thread-multi) installed
in
/usr/local/lib/perl5/site_perl/5.8.8/sun4-solaris-thread-multi/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?)
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)
Skip blib/arch/auto/DBD/Oracle/mk.pm (unchanged)
Skip blib/lib/DBD/Oracle/GetInfo.pm (unchanged)
gcc -c -I/home/oracle/OraHome1/rdbms/demo
-I/home/oracle/OraHome1/rdbms/demo -I/home/oracle/OraHome1/rdbms/public
-I/home/oracle/OraHome1/plsql/public -I/home/oracle/OraHome1/network/public
-I/usr/local/lib/perl5/site_perl/5.8.8/sun4-solaris-thread-multi/auto/DBI
-D_REENTRANT -fno-strict-aliasing -pipe -Wdeclaration-after-statement
-I/usr/local/include -I/opt/local/include -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64 -O -DVERSION=\"1.19\" -DXS_VERSION=\"1.19\" -fPIC
"-I/usr/local/lib/perl5/5.8.8/sun4-solaris-thread-multi/CORE" -Wall
-Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"8.1.7.0\" Oracle.c
gcc -c -I/home/oracle/OraHome1/rdbms/demo
-I/home/oracle/OraHome1/rdbms/demo -I/home/oracle/OraHome1/rdbms/public
-I/home/oracle/OraHome1/plsql/public -I/home/oracle/OraHome1/network/public
-I/usr/local/lib/perl5/site_perl/5.8.8/sun4-solaris-thread-multi/auto/DBI
-D_REENTRANT -fno-strict-aliasing -pipe -Wdeclaration-after-statement
-I/usr/local/include -I/opt/local/include -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64 -O -DVERSION=\"1.19\" -DXS_VERSION=\"1.19\" -fPIC
"-I/usr/local/lib/perl5/5.8.8/sun4-solaris-thread-multi/CORE" -Wall
-Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"8.1.7.0\" dbdimp.c
dbdimp.c: In function `ora_db_login6':
dbdimp.c:456: warning: unused variable `rsize'
dbdimp.c: In function `ora2sql_type':
dbdimp.c:2487: error: `SQLT_TIMESTAMP_LTZ' undeclared (first use in this
function)
dbdimp.c:2487: error: (Each undeclared identifier is reported only once
dbdimp.c:2487: error: for each function it appears in.)
make: *** [dbdimp.o] Error 1
