Date: Thu, 17 Apr 2008 10:36:04 -0400 (EDT)
From: Dunston Rocks <rocksdunston AT yahoo DOT com>
Subject: Re: Trouble installing DBD::Oracle on Cygwin
To: Reini Urban <rurban AT x-ray DOT at>, cygwin AT cygwin DOT com
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Message-ID: <921597.16830.qm@web46003.mail.sp1.yahoo.com>
Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm
Sender: cygwin-owner AT cygwin DOT com
Mail-Followup-To: cygwin AT cygwin DOT com
Content-Transfer-Encoding: 8bit

Hi
I got the OCI Libraries installed and got the make file to get generated without any issues. Now I am encountering the below error trying to run the makefile
$ make
gcc -c  -IC:/oracle/product/9.2.0/client_2/oci/include -IC:/oracle/product/9.2.0/client_2/rdbms/demo -I/usr/lib/perl5/site_perl/5.8/cygwin/auto/DBI -DPERL_USE_SAFE_PUTENV -fno-strict-aliasing -pipe -Wdeclaration-after-statement -DUSEIMPORTLIB -O3   -DVERSION=\"1.21\" -DXS_VERSION=\"1.21\"  "-I/usr/lib/perl5/5.8/cygwin/CORE"  -Wall -Wno-comment -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"9.2.0.1\" Oracle.c
In file included from Oracle.xs:1:
Oracle.h:114: error: conflicting types for 'OCIXMLTypeCreateFromSrc'
Oracle.h:114: note: an argument type that has a default promotion can't match an empty parameter name list declaration
C:/oracle/product/9.2.0/client_2/oci/include/ociap.h:10038: error: previous declaration of 'OCIXMLTypeCreateFromSrc' was here
Oracle.h:114: error: conflicting types for 'OCIXMLTypeCreateFromSrc'
Oracle.h:114: note: an argument type that has a default promotion can't match an empty parameter name list declaration
C:/oracle/product/9.2.0/client_2/oci/include/ociap.h:10038: error: previous declaration of 'OCIXMLTypeCreateFromSrc' was here
make: *** [Oracle.o] Error 1

Has anyone seen this error before?
I scrubbed the system clean of any Oracle Client installation and reinstalled the 9i client in totality.

Thanks
Dunston
----- Original Message ----
From: Reini Urban <rurban AT x-ray DOT at>
To: cygwin AT cygwin DOT com
Sent: Wednesday, April 16, 2008 3:19:54 PM
Subject: Re: Trouble installing DBD::Oracle on Cygwin

2008/4/16, Dunston Rocks:
> Hilling DBD::Oracle on Cygwin
>  Steps followed  :
>   Download from CPAN
>  tar –zxvf  DBD-Oracle-1.20.tar.gz
>  cd DBD-Oracle-1.20
>  make  realclean
>  perl Makefile.pl
>  make : *** [ Oracle.o ]  Error 1 ; output attached (make_results.txt)
>  perl – V (attached :  perl_V.out)
>  make  realclean
>  perl Makefile.pl -g
>  make (Same error as  above in Step 6) ) ;
>  output attached (make_results_debugmode.txt)
>  Oracle 10g Client at  C:\oracle\product\10.2.0\client_2
>  ORACLE_HOME set to  above
>  SQLPLUS set to  "C:\oracle\product\10.2.0\client_2\bin\sqllplus" and
>  am able to connect to all  databases in   C:\oracle\product\10.2.0\client_2\network\ADMIN\tnsnames.ora from cygwin bash shell
>  Cygwin Installation : A  complete installation from latest build from Cygwin.com on April 10th 2008
>  DBI is installed, but  attempting to run code that uses DBD::Oracle throws below error    install_driver(Oracle)  failed: Can't locate DBD/Oracle..pm in @INC (@INC contains: %PERL5LIB%;C  \Documents and Settings\dunston\My  Documents\scripts\parse;C \Program Files\Mozilla  Firefox\tpsf;C \Documents and Settings\dunston\My  Documents\scripts\parse;C \Program Files\Mozilla  Firefox\tpsf /usr/lib/perl5/5.8/cygwin /usr/lib/perl5/5..8  /usr/lib/perl5/site_perl/5.8/cygwin /usr/lib/perl5/site_perl/5.8  /usr/lib/perl5/site_perl/5.8 /usr/lib/perl5/vendor_perl/5.8/cygwin  /usr/lib/perl5/vendor_perl/5..8 /usr/lib/perl5/vendor_perl/5.8 .) at (eval 3)  line 3.

Change your PERL5LIB to a sane value.
I know, Oracle 10 messes up the PERL5LIB environment variable,
because they ship their own perl and apache.
I just unset PERL5LIB and add the POSIX paths of the Oracle dirs to
your perl Makefile.PL
line.

$ PERL5LIB= ORACLE_HOME=/cygdrive/oracle/product/10.2.0/client_2 perl
Makefile.PL

maybe add
-h <path to headers>

Also check out
http://search.cpan.org/src/PYTHIAN/DBD-Oracle-1.21/README.wingcc.txt
if the importlib was correctly created.

>  Would appreciate your input on  installing this library in Cygwin
>   Thanks
>
>
>
>  ------
>  gcc -g -c  -IC:/oracle/product/10.2.0/client_2/oci/include

gcc cannot handle this path anymore!
/cygdrive/c/oracle/product/10.2.0/client_2/oci/include is better.

-IC:/oracle/product/10.2.0/client_2/rdbms/demo
-I/usr/lib/perl5/site_perl/5.8/cygwin/auto/DBI -g
-DPERL_USE_SAFE_PUTENV -fno-strict-aliasing -pipe
-Wdeclaration-after-statement -DUSEIMPORTLIB    -DVERSION=\"1.20\"
-DXS_VERSION=\"1.20\"  "-I/usr/lib/perl5/5.8/cygwin/CORE"  -Wall
-Wno-comment -DUTF8_SUPPORT -DNEW_OCI_INIT
-DORA_OCI_VERSION=\"9.2.0.1\" Oracle.c
>  In file included from Oracle.xs:1:
>  Oracle.h:37:17: oci.h: No such file or directory
>  Oracle.h:39:20: ocidfn.h: No such file or directory
>  Oracle.h:40:18: orid.h: No such file or directory
>  Oracle.h:41:17: ori.h: No such file or directory
-- 
Reini Urban
http://phpwiki.org/              http://murbreak.at/

--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/


      ____________________________________________________________________________________
Be a better friend, newshound, and 
know-it-all with Yahoo! Mobile.  Try it now.  http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/