Hi
I am having trouble installing 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.
I have tried reinstalling the Oracle client on Windows and find that despite
repeated re-installs, the "dll files" are present, but there are no oci.h files
being installed.
Would appreciate your input on installing this library in Cygwin
Thanks
------
gcc -g -c -IC:/oracle/product/10.2.0/client_2/oci/include
-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
In file included from Oracle..h:53,
from Oracle.xs:1:
dbdimp.h:15: error: parse error before "OCIEnv"
dbdimp.h:15: warning: no semicolon at end of struct or union
dbdimp.h:22: error: parse error before '}' token
dbdimp.h:36: error: parse error before "OCIEnv"
dbdimp.h:36: warning: no semicolon at end of struct or union
dbdimp.h:37: warning: type defaults to `int' in declaration of `errhp'
dbdimp.h:37: warning: data definition has no type or storage class
dbdimp.h:38: error: parse error before '*' token
dbdimp.h:38: warning: type defaults to `int' in declaration of `srvhp'
dbdimp.h:38: warning: data definition has no type or storage class
dbdimp.h:39: error: parse error before '*' token
dbdimp.h:39: warning: type defaults to `int' in declaration of `svchp'
dbdimp.h:39: warning: data definition has no type or storage class
dbdimp.h:40: error: parse error before '*' token
dbdimp.h:40: warning: type defaults to `int' in declaration of `authp'
dbdimp.h:40: warning: data definition has no type or storage class
dbdimp.h:49: error: parse error before '}' token
dbdimp.h:64: error: parse error before "OCIEnv"
dbdimp.h:64: warning: no semicolon at end of struct or union
dbdimp.h:65: warning: type defaults to `int' in declaration of `errhp'
dbdimp.h:65: warning: data definition has no type or storage class
dbdimp.h:66: error: parse error before '*' token
dbdimp.h:66: warning: type defaults to `int' in declaration of `srvhp'
dbdimp.h:66: warning: data definition has no type or storage class
dbdimp.h:67: error: parse error before '*' token
dbdimp.h:67: warning: type defaults to `int' in declaration of `svchp'
dbdimp.h:67: warning: data definition has no type or storage class
dbdimp.h:68: error: parse error before '*' token
dbdimp.h:68: warning: type defaults to `int' in declaration of `stmhp'
dbdimp.h:68: warning: data definition has no type or storage class
dbdimp.h:69: error: parse error before '*' token
dbdimp.h:69: warning: type defaults to `int' in declaration of `dschp'
dbdimp.h:69: warning: data definition has no type or storage class
dbdimp.h:102: error: parse error before '}' token
dbdimp.h:121: error: parse error before "OCIParam"
dbdimp.h:121: warning: no semicolon at end of struct or union
dbdimp.h:122: warning: type defaults to `int' in declaration of `parmap'
dbdimp.h:122: warning: data definition has no type or storage class
dbdimp.h:123: error: parse error before '*' token
dbdimp.h:123: warning: type defaults to `int' in declaration of `tdo'
dbdimp.h:123: warning: data definition has no type or storage class
dbdimp.h:124: error: parse error before "typecode"
dbdimp.h:124: warning: type defaults to `int' in declaration of `typecode'
dbdimp.h:124: warning: data definition has no type or storage class
dbdimp.h:125: error: parse error before "col_typecode"
dbdimp.h:125: warning: type defaults to `int' in declaration of `col_typecode'
dbdimp.h:125: warning: data definition has no type or storage class
dbdimp.h:126: error: parse error before "element_typecode"
dbdimp.h:126: warning: type defaults to `int' in declaration of
`element_typecode'
dbdimp.h:126: warning: data definition has no type or storage class
dbdimp.h:127: error: parse error before '*' token
dbdimp.h:127: warning: type defaults to `int' in declaration of `obj_ref'
dbdimp.h:127: warning: data definition has no type or storage class
dbdimp.h:128: error: parse error before '*' token
dbdimp.h:128: warning: type defaults to `int' in declaration of `obj_ind'
dbdimp.h:128: warning: data definition has no type or storage class
dbdimp.h:129: error: parse error before '*' token
dbdimp.h:129: warning: type defaults to `int' in declaration of `obj_value'
dbdimp.h:129: warning: data definition has no type or storage class
dbdimp.h:130: error: parse error before '*' token
dbdimp.h:130: warning: type defaults to `int' in declaration of `obj_type'
dbdimp.h:130: warning: data definition has no type or storage class
dbdimp.h:134: error: parse error before '}' token
dbdimp.h:141: error: parse error before "OCIParam"
dbdimp.h:141: warning: no semicolon at end of struct or union
dbdimp.h:142: warning: type defaults to `int' in declaration of `defnp'
dbdimp.h:142: warning: data definition has no type or storage class
dbdimp.h:170: error: parse error before '}' token
dbdimp.h:192: error: parse error before "OCIBind"
dbdimp.h:192: warning: no semicolon at end of struct or union
dbdimp.h:209: error: parse error before '*' token
dbdimp.h:209: warning: type defaults to `int' in declaration of
`array_indicators'
dbdimp.h:209: warning: data definition has no type or storage class
dbdimp.h:217: error: conflicting types for 'name'
dbdimp.h:152: error: previous declaration of 'name' was here
dbdimp.h:218: error: parse error before '}' token
dbdimp.h:247: error: parse error before "OCILobLocator"
dbdimp.h:260: error: parse error before "OCIError"
dbdimp.h:287: error: parse error before "OCIBind"
dbdimp.h:289: error: parse error before "OCIBind"
In file included from Oracle.c:111:
/usr/lib/perl5/site_perl/5.8/cygwin/auto/DBI/Driver_xst.h: In function
`dbdxst_bind_params':
/usr/lib/perl5/site_perl/5.8/cygwin/auto/DBI/Driver_xst.h:60: error:
dereferencing pointer to incomplete type
/usr/lib/perl5/site_perl/5.8/cygwin/auto/DBI/Driver_xst.h:61: error:
dereferencing pointer to incomplete type
/usr/lib/perl5/site_perl/5.8/cygwin/auto/DBI/Driver_xst.h:65: error:
dereferencing pointer to incomplete type
/usr/lib/perl5/site_perl/5.8/cygwin/auto/DBI/Driver_xst.h:66: error:
dereferencing pointer to incomplete type
/usr/lib/perl5/site_perl/5.8/cygwin/auto/DBI/Driver_xst.h:67: error:
dereferencing pointer to incomplete type
/usr/lib/perl5/site_perl/5.8/cygwin/auto/DBI/Driver_xst.h: In function
`dbdxst_fetchall_arrayref':
/usr/lib/perl5/site_perl/5.8/cygwin/auto/DBI/Driver_xst.h:93: error:
dereferencing pointer to incomplete type
/usr/lib/perl5/site_perl/5.8/cygwin/auto/DBI/Driver_xst.h:94: error:
dereferencing pointer to incomplete type
/usr/lib/perl5/site_perl/5.8/cygwin/auto/DBI/Driver_xst.h:101: error:
dereferencing pointer to incomplete type
Oracle.xsi: In function `XS_DBD__Oracle__db_selectall_arrayref':
Oracle.xsi:140: error: dereferencing pointer to incomplete type
Oracle.xsi: In function `XS_DBD__Oracle__db_selectrow_arrayref':
Oracle.xsi:180: error: dereferencing pointer to incomplete type
Oracle.xsi: In function `XS_DBD__Oracle__db_commit':
Oracle.xsi:259: error: dereferencing pointer to incomplete type
Oracle.xsi:259: error: dereferencing pointer to incomplete type
Oracle.xsi: In function `XS_DBD__Oracle__db_rollback':
Oracle.xsi:269: error: dereferencing pointer to incomplete type
Oracle.xsi:269: error: dereferencing pointer to incomplete type
Oracle.xsi: In function `XS_DBD__Oracle__db_disconnect':
Oracle.xsi:279: error: dereferencing pointer to incomplete type
Oracle.xsi:284: error: dereferencing pointer to incomplete type
Oracle.xsi:284: error: dereferencing pointer to incomplete type
Oracle.xsi:286: error: dereferencing pointer to incomplete type
Oracle.xsi:288: error: dereferencing pointer to incomplete type
Oracle.xsi:292: error: dereferencing pointer to incomplete type
Oracle.xsi:292: error: dereferencing pointer to incomplete type
Oracle.xsi:292: error: dereferencing pointer to incomplete type
Oracle.xsi: In function `XS_DBD__Oracle__db_STORE':
Oracle.xsi:306: error: dereferencing pointer to incomplete type
Oracle.xsi: In function `XS_DBD__Oracle__db_FETCH':
Oracle.xsi:318: error: dereferencing pointer to incomplete type
Oracle.xsi: In function `XS_DBD__Oracle__db_DESTROY':
Oracle.xsi:329: error: dereferencing pointer to incomplete type
Oracle.xsi:331: error: dereferencing pointer to incomplete type
Oracle.xsi:331: error: dereferencing pointer to incomplete type
Oracle.xsi:332: error: dereferencing pointer to incomplete type
Oracle.xsi:337: error: dereferencing pointer to incomplete type
Oracle.xsi:338: error: dereferencing pointer to incomplete type
Oracle.xsi:338: error: dereferencing pointer to incomplete type
Oracle.xsi:338: error: dereferencing pointer to incomplete type
Oracle.xsi:339: error: dereferencing pointer to incomplete type
Oracle.xsi:340: error: dereferencing pointer to incomplete type
Oracle.xsi:342: error: dereferencing pointer to incomplete type
Oracle.xsi:343: error: dereferencing pointer to incomplete type
Oracle.xsi:358: error: dereferencing pointer to incomplete type
Oracle.xsi:359: error: dereferencing pointer to incomplete type
Oracle.xsi:360: error: dereferencing pointer to incomplete type
Oracle.xsi:366: error: dereferencing pointer to incomplete type
Oracle..xsi:366: error: dereferencing pointer to incomplete type
Oracle.xsi:366: error: dereferencing pointer to incomplete type
Oracle.xsi: In function `XS_DBD__Oracle__st_execute':
Oracle.xsi:570: error: dereferencing pointer to incomplete type
Oracle.xsi:571: error: dereferencing pointer to incomplete type
Oracle.xsi: In function `XS_DBD__Oracle__st_finish':
Oracle..xsi:653: error: dereferencing pointer to incomplete type
Oracle.xsi:654: error: dereferencing pointer to incomplete type
Oracle.xsi:658: error: dereferencing pointer to incomplete type
Oracle.xsi:661: error: dereferencing pointer to incomplete type
Oracle.xsi:661: error: dereferencing pointer to incomplete type
Oracle.xsi:661: error: dereferencing pointer to incomplete type
Oracle.xsi: In function `XS_DBD__Oracle__st_STORE':
Oracle.xsi:701: error: dereferencing pointer to incomplete type
Oracle.xsi: In function `XS_DBD__Oracle__st_FETCH_attrib':
Oracle.xsi:718: error: dereferencing pointer to incomplete type
Oracle.xsi: In function `XS_DBD__Oracle__st_DESTROY':
Oracle.xsi:729: error: dereferencing pointer to incomplete type
Oracle.xsi:731: error: dereferencing pointer to incomplete type
Oracle.xsi:731: error: dereferencing pointer to incomplete type
Oracle..xsi:732: error: dereferencing pointer to incomplete type
Oracle.xsi:737: error: dereferencing pointer to incomplete type
Oracle.xsi:738: error: dereferencing pointer to incomplete type
Oracle.xsi:738: error: dereferencing pointer to incomplete type
Oracle.xsi:738: error: dereferencing pointer to incomplete type
Oracle.xsi:739: error: dereferencing pointer to incomplete type
Oracle.xsi:740: error: dereferencing pointer to incomplete type
Oracle.xsi:742: error: dereferencing pointer to incomplete type
Oracle.xsi:743: error: dereferencing pointer to incomplete type
Oracle.xsi:744: error: dereferencing pointer to incomplete type
Oracle.xsi:752: error: dereferencing pointer to incomplete type
Oracle.xsi:752: error: dereferencing pointer to incomplete type
Oracle.xsi:752: error: dereferencing pointer to incomplete type
Oracle.xs: In function `XS_DBD__Oracle__st_ora_fetch':
Oracle.xs:90: error: dereferencing pointer to incomplete type
Oracle.xs:90: error: dereferencing pointer to incomplete type
Oracle.xs:90: error: dereferencing pointer to incomplete type
Oracle.xs:93: error: dereferencing pointer to incomplete type
Oracle.xs:93: error: dereferencing pointer to incomplete type
Oracle.xs:93: error: dereferencing pointer to incomplete type
Oracle.xs:93: warning: left-hand operand of comma expression has no effect
Oracle.xs:93: error: dereferencing pointer to incomplete type
Oracle.xs:93: error: dereferencing pointer to incomplete type
Oracle.xs:93: error: dereferencing pointer to incomplete type
Oracle.xs:93: warning: left-hand operand of comma expression has no effect
Oracle.xs:93: error: dereferencing pointer to incomplete type
Oracle.xs:93: error: dereferencing pointer to incomplete type
Oracle.xs:93: error: dereferencing pointer to incomplete type
Oracle.xs:93: warning: left-hand operand of comma expression has no effect
Oracle.xs:97: error: dereferencing pointer to incomplete type
Oracle.xs:99: error: dereferencing pointer to incomplete type
Oracle.xs:118: error: dereferencing pointer to incomplete type
Oracle.xs:118: error: dereferencing pointer to incomplete type
Oracle..xs:118: error: dereferencing pointer to incomplete type
Oracle.xs:118: error: dereferencing pointer to incomplete type
Oracle.xs:118: error: dereferencing pointer to incomplete type
Oracle.xs:118: error: dereferencing pointer to incomplete type
Oracle.xs:118: error: dereferencing pointer to incomplete type
Oracle.xs:118: error: dereferencing pointer to incomplete type
Oracle.xs:120: error: dereferencing pointer to incomplete type
Oracle.xs:120: error: dereferencing pointer to incomplete type
Oracle.xs: In function `XS_DBD__Oracle__st_ora_execute_array':
Oracle.xs:135: error: dereferencing pointer to incomplete type
Oracle.xs:136: error: dereferencing pointer to incomplete type
Oracle.c: In function `XS_DBD__Oracle__db_ora_lob_write':
Oracle.c:1329: error: `OCILobLocator' undeclared (first use in this function)
Oracle.c:1329: error: (Each undeclared identifier is reported only once
Oracle.c:1329: error: for each function it appears in.)
Oracle.c:1329: error: `locator' undeclared (first use in this function)
Oracle.c:1330: warning: ISO C90 forbids mixed declarations and code
Oracle.c:1344: error: parse error before ')' token
Oracle.c:1343: warning: unused variable `tmp'
Oracle.xs:184: error: `SQLCS_IMPLICIT' undeclared (first use in this function)
Oracle.xs:191: warning: implicit declaration of function `OCILobCharSetForm'
Oracle.xs:191: error: dereferencing pointer to incomplete type
Oracle.xs:191: error: dereferencing pointer to incomplete type
Oracle.xs:191: error: dereferencing pointer to incomplete type
Oracle.xs:191: error: dereferencing pointer to incomplete type
Oracle.xs:192: error: `OCI_SUCCESS' undeclared (first use in this function)
Oracle.xs:193: error: dereferencing pointer to incomplete type
Oracle.xs:207: error: `SQLCS_NCHAR' undeclared (first use in this function)
Oracle.xs:209: warning: implicit declaration of function `OCILobWrite'
Oracle.xs:209: error: dereferencing pointer to incomplete type
Oracle.xs:209: error: dereferencing pointer to incomplete type
Oracle.xs:209: error: `OCI_ONE_PIECE' undeclared (first use in this function)
Oracle.xs:209: error: dereferencing pointer to incomplete type
Oracle.xs:209: error: dereferencing pointer to incomplete type
Oracle.xs:215: error: dereferencing pointer to incomplete type
Oracle.c: In function `XS_DBD__Oracle__db_ora_lob_append':
Oracle.c:1401: error: `OCILobLocator' undeclared (first use in this function)
Oracle.c:1401: error: `locator' undeclared (first use in this function)
Oracle.c:1402: warning: ISO C90 forbids mixed declarations and code
Oracle.c:1418: error: parse error before ')' token
Oracle.c:1417: warning: unused variable `tmp'
Oracle.xs:240: error: `SQLCS_IMPLICIT' undeclared (first use in this function)
Oracle.xs:247: error: dereferencing pointer to incomplete type
Oracle.xs:247: error: dereferencing pointer to incomplete type
Oracle.xs:247: error: dereferencing pointer to incomplete type
Oracle.xs:247: error: dereferencing pointer to incomplete type
Oracle.xs:248: error: `OCI_SUCCESS' undeclared (first use in this function)
Oracle.xs:249: error: dereferencing pointer to incomplete type
Oracle.xs:263: error: `SQLCS_NCHAR' undeclared (first use in this function)
Oracle.xs:277: warning: implicit declaration of function `OCILobGetLength'
Oracle.xs:277: error: dereferencing pointer to incomplete type
Oracle.xs:277: error: dereferencing pointer to incomplete type
Oracle.xs:277: error: dereferencing pointer to incomplete type
Oracle.xs:277: error: dereferencing pointer to incomplete type
Oracle.xs:279: error: dereferencing pointer to incomplete type
Oracle.xs:286: error: dereferencing pointer to incomplete type
Oracle.xs:286: error: dereferencing pointer to incomplete type
Oracle.xs:286: error: `OCI_ONE_PIECE' undeclared (first use in this function)
Oracle.xs:286: error: dereferencing pointer to incomplete type
Oracle.xs:286: error: dereferencing pointer to incomplete type
Oracle..xs:292: error: dereferencing pointer to incomplete type
Oracle.c: In function `XS_DBD__Oracle__db_ora_lob_read':
Oracle.c:1498: error: `OCILobLocator' undeclared (first use in this function)
Oracle.c:1498: error: `locator' undeclared (first use in this function)
Oracle.c:1499: warning: ISO C90 forbids mixed declarations and code
Oracle.c:1513: error: parse error before ')' token
Oracle.c:1512: warning: unused variable `tmp'
Oracle.xs:317: error: `SQLCS_IMPLICIT' undeclared (first use in this function)
Oracle.xs:327: error: dereferencing pointer to incomplete type
Oracle.xs:327: error: dereferencing pointer to incomplete type
Oracle.xs:327: error: dereferencing pointer to incomplete type
Oracle.xs:327: error: dereferencing pointer to incomplete type
Oracle.xs:328: error: `OCI_SUCCESS' undeclared (first use in this function)
Oracle.xs:329: error: dereferencing pointer to incomplete type
Oracle.xs:333: warning: implicit declaration of function `OCILobRead'
Oracle.xs:333: error: dereferencing pointer to incomplete type
Oracle.xs:333: error: dereferencing pointer to incomplete type
Oracle.xs:333: error: dereferencing pointer to incomplete type
Oracle.xs:333: error: dereferencing pointer to incomplete type
Oracle.xs:338: error: dereferencing pointer to incomplete type
Oracle.xs:344: error: `SQLCS_NCHAR' undeclared (first use in this function)
Oracle.c: In function `XS_DBD__Oracle__db_ora_lob_trim':
Oracle.c:1564: error: `OCILobLocator' undeclared (first use in this function)
Oracle.c:1564: error: `locator' undeclared (first use in this function)
Oracle.c:1565: warning: ISO C90 forbids mixed declarations and code
Oracle.c:1573: error: parse error before ')' token
Oracle.c:1572: warning: unused variable `tmp'
Oracle.xs:359: warning: implicit declaration of function `OCILobTrim'
Oracle.xs:359: error: dereferencing pointer to incomplete type
Oracle.xs:359: error: dereferencing pointer to incomplete type
Oracle.xs:359: error: dereferencing pointer to incomplete type
Oracle.xs:359: error: dereferencing pointer to incomplete type
Oracle.xs:360: error: `OCI_SUCCESS' undeclared (first use in this function)
Oracle.xs:361: error: dereferencing pointer to incomplete type
Oracle.c: In function `XS_DBD__Oracle__db_ora_lob_length':
Oracle.c:1600: error: `OCILobLocator' undeclared (first use in this function)
Oracle.c:1600: error: `locator' undeclared (first use in this function)
Oracle.xs:373: warning: ISO C90 forbids mixed declarations and code
Oracle.c:1609: error: parse error before ')' token
Oracle.c:1608: warning: unused variable `tmp'
Oracle.xs:377: error: dereferencing pointer to incomplete type
Oracle.xs:377: error: dereferencing pointer to incomplete type
Oracle.xs:377: error: dereferencing pointer to incomplete type
Oracle.xs:377: error: dereferencing pointer to incomplete type
Oracle.xs:378: error: `OCI_SUCCESS' undeclared (first use in this function)
Oracle.xs:379: error: dereferencing pointer to incomplete type
Oracle.c: In function `boot_DBD__Oracle':
Oracle.c:1670: error: `SQLCS_IMPLICIT' undeclared (first use in this function)
Oracle.c:1684: error: `SQLCS_NCHAR' undeclared (first use in this function)
Oracle.c:1688: error: `SQLT_INT' undeclared (first use in this function)
Oracle.c:1694: error: `SQLT_FLT' undeclared (first use in this function)
Oracle.xsi:21: error: invalid application of `sizeof' to incomplete type
`/usr/lib/perl5/site_perl/5.8/cygwin/auto/DBI/DBIXS.h'
Oracle.xsi:22: error: invalid application of `sizeof' to incomplete type
`/usr/lib/perl5/site_perl/5.8/cygwin/auto/DBI/DBIXS.h'
Oracle..xsi:23: error: invalid application of `sizeof' to incomplete type
`/usr/lib/perl5/site_perl/5.8/cygwin/auto/DBI/DBIXS.h'
make: *** [Oracle.o] Error 1
____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
