[Wellington-pm] building DBD::Oracle

[Geoff Cant]

I'm just running out in a second, but we've been through libdbd-oracle- 
perl + oracle-instantclient PAIN repeatedly here at catalyst  
(grr at oracle).

http://git.catalyst.net.nz/gw?p=oracle-instantclient.git;a=summary is  
our debian packaging of the instant client
To use:
  clone the repo,
  cd oracle-instantclient
  grab {sdk,sqlplus,basic,odbc}.zip of the oracle 11i instant client  
for the arch of your choice,
  rename *.zip to *-$arch.zip (See the makefile)
  dpkg-buildpackage -rfakeroot
  dpkg -i ../oracle-instantclient*.deb

http://git.catalyst.net.nz/gw?p=libdbd-oracle-perl.git;a=summary is  
our debian packaging of libdbd-oracle-perl built against the above.
To use:
  install oracle-instantclient (see above)
  clone the repo
  cd libdbd-oracle-perl
  source /etc/oraenv
  dpkg-buildpackage -rfakeroot # this will whinge, but should build a  
package

Let me know how you get on - drop me an email if you get stuck.

Cheers,
--Geoff Cant (Catalyst IT)


On 2008-02-05, at 17:16 , Peter Love wrote:

> Hi All,
>
> Has anyone built DBD::Oracle using Oracle instant client on Debian  
> etch?
>
> I've followed the approach at
> http://jeanchristophe.duber.free.fr/dbd_oracle_instantclient_linux/
>
> But at the make stage I'm getting the errors appended below.
>
> Any suggestions appreciated.
>
>
> Peter
>
> --
>
>
> cc -c  -I/usr/lib/perl5/auto/DBI
> -I/usr/local/oracle_instantclient/include -O2   -DVERSION=\"1.20\"
> -DXS_VERSION=\"1.20\" -fPIC -fno-strict-aliasing
> "-I/usr/lib/perl/5.8/CORE"  -Wall -Wcast-align -Wpointer-arith
> -DORA_OCI_VERSION=\"10.2.0.3\" Oracle.c
> In file included from /usr/lib/perl/5.8/CORE/op.h:497,
>                  from /usr/lib/perl/5.8/CORE/perl.h:2754,
>                  from /usr/lib/perl5/auto/DBI/DBIXS.h:19,
>                  from Oracle.h:51,
>                  from Oracle.xs:1:
> /usr/lib/perl/5.8/CORE/reentr.h:612: error: field ‘_crypt_struct’ has
> incomplete type
> In file included from /usr/lib/perl/5.8/CORE/perl.h:3950,
>                  from /usr/lib/perl5/auto/DBI/DBIXS.h:19,
>                  from Oracle.h:51,
>                  from Oracle.xs:1:
> /usr/lib/perl/5.8/CORE/proto.h:297: error: expected declaration
> specifiers or ‘...’ before ‘off64_t’
> /usr/lib/perl/5.8/CORE/proto.h:299: error: expected ‘=’, ‘,’, ‘;’,  
> ‘asm’
> or ‘__attribute__’ before ‘Perl_do_sysseek’
> /usr/lib/perl/5.8/CORE/proto.h:300: error: expected ‘=’, ‘,’, ‘;’,  
> ‘asm’
> or ‘__attribute__’ before ‘Perl_do_tell’
> /usr/lib/perl/5.8/CORE/proto.h:2004: error: expected ‘=’, ‘,’, ‘;’,
> ‘asm’ or ‘__attribute__’ before ‘Perl_PerlIO_tell’
> /usr/lib/perl/5.8/CORE/proto.h:2005: error: expected declaration
> specifiers or ‘...’ before ‘off64_t’
>
>
>
> _______________________________________________
> Wellington-pm mailing list
> Wellington-pm at pm.org
> http://mail.pm.org/mailman/listinfo/wellington-pm
>