Me thinks your Perl was compiled using one flavour of C compiler and you
are trying to compile DBD::Oracle with another flavour or C compiler.
I have seen this a number of times with HP systems.
Basically it meas you have to recompile your Perl with the same C
compiler you are going to use to compile DBD::ORacle and your other perl
mods.
Do a Google search for
Oracle.c: In function `XS_DBD__Oracle_constant':
you will find a number of other hits in the list that are similar.
Unfortunately that is all the help I can offer as I have never had to do
this myself
Stewart Anderson wrote:
Thanks for the response John.
I just tried the same thing on perl 5.10 and had the same results.
Perl Makefile.PL and make output shown below.
Perl Makefile.PL looks ok to me - but I am far from expert,
clearly!!
I can see a problem with the includes in the make output but do not
know how to correct this, I thought the Makefile looked at the
INCLUDE env var, which I tried to set with paths to the stdarg.h
but that did not help at all.
I appreciate your help :)
Regards
Stu
Perl Makefile.PL Output
========================================================================
=
perl Makefile.PL
Using DBI 1.601 (for perl 5.010000 on darwin-thread-multi-2level)
installed in /usr/local/ActivePerl-5.10/lib/auto/DBI/
Argument "6.42_01" isn't numeric in numeric ge (>=) at Makefile.PL line
59.
Configuring DBD::Oracle for perl 5.010000 on darwin
(darwin-thread-multi-2level)
Remember to actually *READ* the README file! Especially if you have any
problems.
Using Oracle in /usr/local/oracle/instantclient10_1
DEFINE _SQLPLUS_RELEASE = "1001000300" (CHAR)
Oracle version 10.1.0.3 (10.1)
Looks like an Instant Client installation, okay
Your DYLD_LIBRARY_PATH env var is set to
'/usr/local/oracle/instantclient10_1:'
Oracle sysliblist:
Found header files in /usr/local/oracle/instantclient10_1/sdk/include.
Checking for functioning wait.ph
System: perl5.010000 darwin sphinx 8.11.0 darwin kernel version 8.11.0:
wed oct 10 18:26:00 pdt 2007; root:xnu-792.24.17~1release_ppc power
macintosh powerpc
Compiler: gcc -O3 -fno-common -DPERL_DARWIN -no-cpp-precomp -arch ppc
-arch i386 -nostdinc -B/Developer/SDKs/MacOSX10.4u.sdk/usr/include/gcc
-B/Developer/SDKs/MacOSX10.4u.sdk/usr/lib/gcc
-isystem/Developer/SDKs/MacOSX10.4u.sdk/usr/include
-F/Developer/SDKs/MacOSX10.4u.sdk/System/Library/Frameworks
-mmacosx-version-min=10.3 -DUSE_SITECUSTOMIZE -DPRIVLIB_LAST_IN_INC
-fno-strict-aliasing -pipe
Linker: /usr/bin/ld
Sysliblist:
Linking with -lclntsh.
LD_RUN_PATH=/usr/local/oracle/instantclient10_1
Using DBD::Oracle 1.21.
Using DBD::Oracle 1.21.
Using DBI 1.601 (for perl 5.010000 on darwin-thread-multi-2level)
installed in /usr/local/ActivePerl-5.10/lib/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 output
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/usr/local/oracle/instantclient10_1/sdk/include
-I/usr/local/ActivePerl-5.10/lib/auto/DBI -fno-common -DPERL_DARWIN
-no-cpp-precomp -arch ppc -arch i386 -nostdinc
-B/Developer/SDKs/MacOSX10.4u.sdk/usr/include/gcc
-B/Developer/SDKs/MacOSX10.4u.sdk/usr/lib/gcc
-isystem/Developer/SDKs/MacOSX10.4u.sdk/usr/include
-F/Developer/SDKs/MacOSX10.4u.sdk/System/Library/Frameworks
-mmacosx-version-min=10.3 -DUSE_SITECUSTOMIZE -DPRIVLIB_LAST_IN_INC
-fno-strict-aliasing -pipe -O3 -DVERSION=\"1.21\"
-DXS_VERSION=\"1.21\" "-I/usr/local/ActivePerl-5.10/lib/CORE" -Wall
-Wno-comment -DUTF8_SUPPORT -DNEW_OCI_INIT
-DORA_OCI_VERSION=\"10.1.0.3\" Oracle.c
In file included from
/usr/local/oracle/instantclient10_1/sdk/include/ociap.h:197,
from
/usr/local/oracle/instantclient10_1/sdk/include/oci.h:2351,
from Oracle.h:37,
from Oracle.xs:1:
/Developer/SDKs/MacOSX10.4u.sdk/usr/include/stdarg.h:4:25: no include
path in which to find stdarg.h
In file included from
/usr/local/oracle/instantclient10_1/sdk/include/oci.h:2351,
from Oracle.h:37,
from Oracle.xs:1:
/usr/local/oracle/instantclient10_1/sdk/include/ociap.h:6267: error:
parse error before "va_list"
In file included from /usr/local/ActivePerl-5.10/lib/CORE/perl.h:598,
from
/usr/local/ActivePerl-5.10/lib/auto/DBI/DBIXS.h:19,
from Oracle.h:51,
from Oracle.xs:1:
/Developer/SDKs/MacOSX10.4u.sdk/usr/include/stdarg.h:4:25: no include
path in which to find stdarg.h
In file included from /usr/local/ActivePerl-5.10/lib/CORE/perl.h:1776,
from
/usr/local/ActivePerl-5.10/lib/auto/DBI/DBIXS.h:19,
from Oracle.h:51,
from Oracle.xs:1:
/Developer/SDKs/MacOSX10.4u.sdk/usr/include/float.h:8:24: no include
path in which to find float.h
In file included from /usr/local/ActivePerl-5.10/lib/CORE/perl.h:1798,
from
/usr/local/ActivePerl-5.10/lib/auto/DBI/DBIXS.h:19,
from Oracle.h:51,
from Oracle.xs:1:
/Developer/SDKs/MacOSX10.4u.sdk/usr/include/float.h:8:24: no include
path in which to find float.h
Oracle.c: In function `XS_DBD__Oracle_constant':
Oracle.c:26: warning: unused variable `Perl___notused'
Oracle.c: In function `XS_DBD__Oracle_ORA_OCI':
Oracle.c:61: warning: unused variable `Perl___notused'
Oracle.c: In function `XS_DBD__Oracle_ora_env_var':
Oracle.c:85: warning: unused variable `Perl___notused'
Oracle.c: In function `XS_DBD__Oracle__db__login':
Oracle.c:215: warning: unused variable `Perl___notused'
Oracle.c: In function `XS_DBD__Oracle__db_selectall_arrayref':
Oracle.c:256: warning: unused variable `Perl___notused'
Oracle.c: In function `XS_DBD__Oracle__db_selectrow_arrayref':
Oracle.c:317: warning: unused variable `Perl___notused'
Oracle.c: In function `XS_DBD__Oracle__db_commit':
Oracle.c:477: warning: unused variable `Perl___notused'
Oracle.c: In function `XS_DBD__Oracle__db_rollback':
Oracle.c:501: warning: unused variable `Perl___notused'
Oracle.c: In function `XS_DBD__Oracle__db_disconnect':
Oracle.c:525: warning: unused variable `Perl___notused'
Oracle.c: In function `XS_DBD__Oracle__db_STORE':
Oracle.c:560: warning: unused variable `Perl___notused'
Oracle.c: In function `XS_DBD__Oracle__db_FETCH':
Oracle.c:589: warning: unused variable `Perl___notused'
Oracle.c: In function `XS_DBD__Oracle__db_DESTROY':
Oracle.c:615: warning: unused variable `Perl___notused'
Oracle.c: In function `XS_DBD__Oracle__st__prepare':
Oracle.c:762: warning: unused variable `Perl___notused'
Oracle.c: In function `XS_DBD__Oracle__st_rows':
Oracle.c:802: warning: unused variable `Perl___notused'
Oracle.c: In function `XS_DBD__Oracle__st_bind_param':
Oracle.c:886: warning: unused variable `Perl___notused'
Oracle.c: In function `XS_DBD__Oracle__st_bind_param_inout':
Oracle.c:935: warning: unused variable `Perl___notused'
Oracle.c: In function `XS_DBD__Oracle__st_execute':
Oracle.c:990: warning: unused variable `Perl___notused'
Oracle.c: In function `XS_DBD__Oracle__st_fetchrow_arrayref':
Oracle.c:1064: warning: unused variable `Perl___notused'
Oracle.c: In function `XS_DBD__Oracle__st_fetchrow_array':
Oracle.c:1090: warning: unused variable `Perl___notused'
Oracle.c: In function `XS_DBD__Oracle__st_fetchall_arrayref':
Oracle.c:1126: warning: unused variable `Perl___notused'
Oracle.c: In function `XS_DBD__Oracle__st_finish':
Oracle.c:1166: warning: unused variable `Perl___notused'
Oracle.c: In function `XS_DBD__Oracle__st_blob_read':
Oracle.c:1203: warning: unused variable `Perl___notused'
Oracle.c: In function `XS_DBD__Oracle__st_STORE':
Oracle.c:1248: warning: unused variable `Perl___notused'
Oracle.c: In function `XS_DBD__Oracle__st_FETCH_attrib':
Oracle.c:1277: warning: unused variable `Perl___notused'
Oracle.c: In function `XS_DBD__Oracle__st_DESTROY':
Oracle.c:1306: warning: unused variable `Perl___notused'
Oracle.c: In function `XS_DBD__Oracle__st_ora_scroll_position':
Oracle.c:1363: warning: unused variable `Perl___notused'
Oracle.c: In function `XS_DBD__Oracle__st_ora_fetch_scroll':
Oracle.c:1389: warning: unused variable `Perl___notused'
Oracle.c: In function `XS_DBD__Oracle__st_ora_bind_param_inout_array':
Oracle.c:1421: warning: unused variable `Perl___notused'
Oracle.c: In function `XS_DBD__Oracle__st_ora_fetch':
Oracle.c:1468: warning: unused variable `Perl___notused'
Oracle.c: In function `XS_DBD__Oracle__st_ora_execute_array':
Oracle.c:1528: warning: unused variable `Perl___notused'
Oracle.c: In function `XS_DBD__Oracle__st_cancel':
Oracle.c:1576: warning: unused variable `Perl___notused'
Oracle.c: In function `XS_DBD__Oracle__db_reauthenticate':
Oracle.c:1598: warning: unused variable `Perl___notused'
Oracle.c: In function `XS_DBD__Oracle__db_ora_lob_write':
Oracle.c:1622: warning: unused variable `Perl___notused'
Oracle.c: In function `XS_DBD__Oracle__db_ora_lob_append':
Oracle.c:1701: warning: unused variable `Perl___notused'
Oracle.c: In function `XS_DBD__Oracle__db_ora_lob_read':
Oracle.c:1805: warning: unused variable `Perl___notused'
Oracle.c: In function `XS_DBD__Oracle__db_ora_lob_trim':
Oracle.c:1878: warning: unused variable `Perl___notused'
Oracle.c: In function `XS_DBD__Oracle__db_ora_lob_length':
Oracle.c:1921: warning: unused variable `Perl___notused'
Oracle.c: In function `XS_DBD__Oracle__dr_init_oci':
Oracle.c:1964: warning: unused variable `Perl___notused'
Oracle.c: In function `boot_DBD__Oracle':
Oracle.c:1989: warning: unused variable `Perl___notused'
make: *** [Oracle.o] Error 1
Information in this email including any attachments may be privileged,
confidential and is intended exclusively for the addressee. The views expressed
may not be official policy, but the personal views of the originator. If you
have received it in error, please notify the sender by return e-mail and delete
it from your system. You should not reproduce, distribute, store, retransmit,
use or disclose its contents to anyone. Please note we reserve the right to
monitor all e-mail communication through our internal and external networks.
SKY and the SKY marks are trade marks of British Sky Broadcasting Group plc and
are used under licence. British Sky Broadcasting Limited (Registration No.
2906991), Sky Interactive Limited (Registration No. 3554332), Sky-In-Home
Service Limited (Registration No. 2067075) and Sky Subscribers Services Limited
(Registration No. 2340150) are direct or indirect subsidiaries of British Sky
Broadcasting Group plc (Registration No. 2247735). All of the companies
mentioned in this paragraph are incorporated in England and Wales and share the
same registered office at Grant Way, Isleworth, Middlesex TW7 5QD.
