Thread: Acess Oracle with dbi-link (PostgreSQL) Error Compile

Emanuel Araújo wrote:
> I'm having trouble making a base to access Oracle via dbi-link, because when installing DBD::Oracle
> version 1.58 the same mistakes some missing files. Ago as "oci.h", it is being called within the
> oracle.h
>
> The purpose would be to sync data between two tools for integration.
>
> Has anyone experienced this?
> Have any solution or suggestion?
> There is another tool that I could be using to make this access?
>
> The following error returned by Perl when you squeegee "make"
>
> make
> gcc-c-D_REENTRANT-D_GNU_SOURCE -I/root/perl5/lib/perl5/x86_64-linux-thread-multi/auto/DBI-fno-strict-
> aliasing-pipe-fstack-protector -I/usr/local/include - D_LARGEFILE_SOURCE-D_FILE_OFFSET_BITS = 64-g-O2-
> pipe-Wall-Wp,-D_FORTIFY_SOURCE = 2-fexceptions-fstack-protector - param = ssp-buffer-size = 4-m64-
> mtune = generic-DVERSION = \ "1:58 \ "-DXS_VERSION = \" 1:58 \ "-fPIC" -I/usr/lib64/perl5/CORE "-Wall-
> Won-comment-DUTF8_SUPPORT-DORA_OCI_VERSION = \" 10.2.0.3 \ "-DORA_OCI_102 Oracle.c
> In file included from Oracle.xs: 1:0:
> Oracle.h: 37:17: fatal error: oci.h: File or directory not found
> compilation terminated.
> make: ** [Oracle.o] Error 1

You need Oracle's header files.
In Instant Client they are called "SDK", and in the regular Oracle
client installation they are called "Programmer" or some similar
cryptic name.  If in doubt, install everything.

If you have PostgreSQL 9.1 or later, you could consider using
oracle_fdw (http://oracle-fdw.projects.pgfoundry.org/).

Yours,
Laurenz Albe