This is the mail archive of the cygwin@cygwin.com mailing list for the Cygwin project.


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]
Other format: [Raw text]

Re: Linking Perl DBD::Oracle with Oracle 9.2 stropped OCI.DLL


I thought the Doc was somewhat convoluted,  so I won't say RTFM,  though it
is all there...  here is a quicky:

1 Make sure you have installed the COMPLETE Admin/developer version of 9.2
( with all libs!!! and headers not just oramts.lib under
/ora92/oci/lib/msvc)  You must install ALL..

2  make sure your oracle home variable is set (ex
ORACLE_HOME=c:\oracle\ora92)

3 make and Install DBI ( I use DBI-1.32.tar.gz).  perl Makefile.pl
make install

4 I use DBD-Oracle-1.12.tar.gz
5 read "README.wingcc"  especially under "BUGS" specifically:  " - liboci.a
must be made before running Makefile.PL
  otherwise it will not be added to link list."

6 dlltool --input-def oci.def --output-lib liboci.a

7 make sure there aren't duplicate liboci.a's in the lib path.

8 NOW perl Makefile.pl (install DBI)







----- Original Message -----
From: "Baras, Gal" <Gal dot Baras at det dot qld dot gov dot au>
To: <cygwin at cygwin dot com>
Sent: Sunday, February 23, 2003 8:36 PM
Subject: Linking Perl DBD::Oracle with Oracle 9.2 stropped OCI.DLL


> Hell
>
> I'm trying to install the DBD::Oracle Perl module.  I've tried creating
> oci.def file from the Oracle 9.2 OCI.DLL library, but it is stripped and
> nothing gets listed.  I've downloaded a tool that converted OCI.DLL to
> OCI.LIB (a static library), from which I could get the exported symbols
into
> oci.def, but still I get the same results:
>
> 1.  perl Makefile.PL tells me that it cannot find -loci (saying it's not a
> big deal)
>
> 2.  make produces the following output (error, really):
>
> gcc -c -I/cygdrive/c/oracle/ora92/oci/include
> -I/cygdrive/c/oracle/ora92/rdbms/demo
> -I/usr/lib/perl5/site_perl/5.6.1/cygwin-multi/auto/DBI
> -DPERL_USE_SAFE_PUTENV -fno-strict-aliasing -I/usr/local/include
> -DUSEIMPORTLIB -O2   -DVERSION=\"1.12\" -DXS_VERSION=\"1.12\"
> -I/usr/lib/perl5/5.6.1/cygwin-multi/CORE  Oracle.c
> In file included from Oracle.h:20,
>                  from Oracle.xs:1:
> dbdimp.h:44:20: ocidfn.h: No such file or directory
> dbdimp.h:57:21: ociapr.h: No such file or directory
> In file included from Oracle.h:20,
>                  from Oracle.xs:1:
> dbdimp.h:97: parse error before "Lda_Def"
> dbdimp.h:97: warning: no semicolon at end of struct or union
> dbdimp.h:98: warning: data definition has no type or storage class
> dbdimp.h:105: parse error before '}' token
> dbdimp.h:126: parse error before "Cda_Def"
> dbdimp.h:126: warning: no semicolon at end of struct or union
> dbdimp.h:127: warning: data definition has no type or storage class
> dbdimp.h:153: parse error before '}' token
> dbdimp.h:279: parse error before "Lda_Def"
> In file included from Oracle.c:52:
> /usr/lib/perl5/site_perl/5.6.1/cygwin-multi/auto/DBI/Driver_xst.h: In
> function `dbdxst_bind_params':
> /usr/lib/perl5/site_perl/5.6.1/cygwin-multi/auto/DBI/Driver_xst.h:48:
> dereferencing pointer to incomplete type
> /usr/lib/perl5/site_perl/5.6.1/cygwin-multi/auto/DBI/Driver_xst.h:49:
> dereferencing pointer to incomplete type
> /usr/lib/perl5/site_perl/5.6.1/cygwin-multi/auto/DBI/Driver_xst.h:53:
> dereferencing pointer to incomplete type
> /usr/lib/perl5/site_perl/5.6.1/cygwin-multi/auto/DBI/Driver_xst.h:54:
> dereferencing pointer to incomplete type
> /usr/lib/perl5/site_perl/5.6.1/cygwin-multi/auto/DBI/Driver_xst.h:55:
> dereferencing pointer to incomplete type
> /usr/lib/perl5/site_perl/5.6.1/cygwin-multi/auto/DBI/Driver_xst.h: In
> function `dbdxst_fetchall_arrayref':
> /usr/lib/perl5/site_perl/5.6.1/cygwin-multi/auto/DBI/Driver_xst.h:80:
> dereferencing pointer to incomplete type
> /usr/lib/perl5/site_perl/5.6.1/cygwin-multi/auto/DBI/Driver_xst.h:81:
> dereferencing pointer to incomplete type
> /usr/lib/perl5/site_perl/5.6.1/cygwin-multi/auto/DBI/Driver_xst.h:88:
> dereferencing pointer to incomplete type
> Oracle.xsi: In function `XS_DBD__Oracle__db_selectall_arrayref':
> Oracle.xsi:107: dereferencing pointer to incomplete type
> Oracle.xsi: In function `XS_DBD__Oracle__db_selectrow_arrayref':
> Oracle.xsi:142: dereferencing pointer to incomplete type
> Oracle.xsi: In function `XS_DBD__Oracle__db_commit':
> Oracle.xsi:179: dereferencing pointer to incomplete type
> Oracle.xsi:179: dereferencing pointer to incomplete type
> Oracle.xsi: In function `XS_DBD__Oracle__db_rollback':
> Oracle.xsi:188: dereferencing pointer to incomplete type
> Oracle.xsi:188: dereferencing pointer to incomplete type
> Oracle.xsi: In function `XS_DBD__Oracle__db_disconnect':
> Oracle.xsi:197: dereferencing pointer to incomplete type
> Oracle.xsi:201: dereferencing pointer to incomplete type
> Oracle.xsi:202: dereferencing pointer to incomplete type
> Oracle.xsi:203: dereferencing pointer to incomplete type
> Oracle.xsi:207: dereferencing pointer to incomplete type
> Oracle.xsi:207: dereferencing pointer to incomplete type
> Oracle.xsi:209: dereferencing pointer to incomplete type
> Oracle.xsi:211: dereferencing pointer to incomplete type
> Oracle.xsi:215: dereferencing pointer to incomplete type
> Oracle.xsi:215: dereferencing pointer to incomplete type
> Oracle.xsi:215: dereferencing pointer to incomplete type
> Oracle.xsi: In function `XS_DBD__Oracle__db_STORE':
> Oracle.xsi:229: dereferencing pointer to incomplete type
> Oracle.xsi: In function `XS_DBD__Oracle__db_FETCH':
> Oracle.xsi:240: dereferencing pointer to incomplete type
> Oracle.xsi: In function `XS_DBD__Oracle__db_DESTROY':
> Oracle.xsi:250: dereferencing pointer to incomplete type
> Oracle.xsi:252: dereferencing pointer to incomplete type
> Oracle.xsi:252: dereferencing pointer to incomplete type
> Oracle.xsi:259: dereferencing pointer to incomplete type
> Oracle.xsi:260: dereferencing pointer to incomplete type
> Oracle.xsi:261: dereferencing pointer to incomplete type
> Oracle.xsi:263: dereferencing pointer to incomplete type
> Oracle.xsi:264: dereferencing pointer to incomplete type
> Oracle.xsi:264: dereferencing pointer to incomplete type
> Oracle.xsi:264: dereferencing pointer to incomplete type
> Oracle.xsi:266: dereferencing pointer to incomplete type
> Oracle.xsi:274: dereferencing pointer to incomplete type
> Oracle.xsi:275: dereferencing pointer to incomplete type
> Oracle.xsi:275: dereferencing pointer to incomplete type
> Oracle.xsi:280: dereferencing pointer to incomplete type
> Oracle.xsi:280: dereferencing pointer to incomplete type
> Oracle.xsi:280: dereferencing pointer to incomplete type
> Oracle.xsi: In function `XS_DBD__Oracle__st_execute':
> Oracle.xsi:396: dereferencing pointer to incomplete type
> Oracle.xsi:397: dereferencing pointer to incomplete type
> Oracle.xsi: In function `XS_DBD__Oracle__st_finish':
> Oracle.xsi:460: dereferencing pointer to incomplete type
> Oracle.xsi:461: dereferencing pointer to incomplete type
> Oracle.xsi:465: dereferencing pointer to incomplete type
> Oracle.xsi:468: dereferencing pointer to incomplete type
> Oracle.xsi:468: dereferencing pointer to incomplete type
> Oracle.xsi:468: dereferencing pointer to incomplete type
> Oracle.xsi: In function `XS_DBD__Oracle__st_STORE':
> Oracle.xsi:508: dereferencing pointer to incomplete type
> Oracle.xsi: In function `XS_DBD__Oracle__st_FETCH_attrib':
> Oracle.xsi:525: dereferencing pointer to incomplete type
> Oracle.xsi: In function `XS_DBD__Oracle__st_DESTROY':
> Oracle.xsi:535: dereferencing pointer to incomplete type
> Oracle.xsi:537: dereferencing pointer to incomplete type
> Oracle.xsi:537: dereferencing pointer to incomplete type
> Oracle.xsi:543: dereferencing pointer to incomplete type
> Oracle.xsi:544: dereferencing pointer to incomplete type
> Oracle.xsi:544: dereferencing pointer to incomplete type
> Oracle.xsi:544: dereferencing pointer to incomplete type
> Oracle.xsi:546: dereferencing pointer to incomplete type
> Oracle.xsi:547: dereferencing pointer to incomplete type
> Oracle.xsi:548: dereferencing pointer to incomplete type
> Oracle.xsi:556: dereferencing pointer to incomplete type
> Oracle.xsi:556: dereferencing pointer to incomplete type
> Oracle.xsi:556: dereferencing pointer to incomplete type
> Oracle.xs: In function `XS_DBD__Oracle__st_ora_fetch':
> Oracle.xs:57: dereferencing pointer to incomplete type
> Oracle.xs:57: dereferencing pointer to incomplete type
> Oracle.xs:57: dereferencing pointer to incomplete type
> Oracle.xs:60: dereferencing pointer to incomplete type
> Oracle.xs:60: dereferencing pointer to incomplete type
> Oracle.xs:60: dereferencing pointer to incomplete type
> Oracle.xs:60: dereferencing pointer to incomplete type
> Oracle.xs:60: dereferencing pointer to incomplete type
> Oracle.xs:60: dereferencing pointer to incomplete type
> Oracle.xs:60: dereferencing pointer to incomplete type
> Oracle.xs:60: dereferencing pointer to incomplete type
> Oracle.xs:64: dereferencing pointer to incomplete type
> Oracle.xs:66: dereferencing pointer to incomplete type
> Oracle.xs:85: dereferencing pointer to incomplete type
> Oracle.xs:85: dereferencing pointer to incomplete type
> Oracle.xs:85: dereferencing pointer to incomplete type
> Oracle.xs:85: dereferencing pointer to incomplete type
> Oracle.xs:85: dereferencing pointer to incomplete type
> Oracle.xs:85: dereferencing pointer to incomplete type
> Oracle.xs:85: dereferencing pointer to incomplete type
> Oracle.xs:85: dereferencing pointer to incomplete type
> Oracle.xs:87: dereferencing pointer to incomplete type
> Oracle.xs:87: dereferencing pointer to incomplete type
> Oracle.xsi: In function `boot_DBD__Oracle':
> Oracle.xsi:21: sizeof applied to an incomplete type
> Oracle.xsi:22: sizeof applied to an incomplete type
> make: *** [Oracle.o] Error 1
>
> Is there anywhere to get suitable libraries for Cygwin?
>
> Is there any way to overcome this using the existing files?
>
> Thanks,
> Gal
> This email (including any attached file) is intended only for the
> addressee(s). The advice given may be specific to a particular situation
and
> the author disclaims liability for its use for any purpose other than that
> originally intended by the author. Any transmission or distribution of
this
> email (whether in whole or in part) is strictly prohibited without the
> author's prior informed consent. Opinions expressed in this email are
those
> of the sender and do not necessarily represent the views of the Department
> of Employment and Training. The legal privilege and confidentiality
attached
> to this email is not waived, lost or destroyed by reason of a mistaken
> delivery to you. If you have received this email in error, please
> immediately notify the author by telephone and delete this message and any
> copies of this message from your computer system network. Thank you
>
> --
> Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
> Bug reporting:         http://cygwin.com/bugs.html
> Documentation:         http://cygwin.com/docs.html
> FAQ:                   http://cygwin.com/faq/
>


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Bug reporting:         http://cygwin.com/bugs.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]