Re: compiling DBD module on system with multiple versions of oracle




if you have a system with multiple versions of oracle and using Perl DBI and
DBD modules.

how to use/setup the DBD module to work on any version of oracle. In
otherwords which oracle environment am i going to use?

Most likly the first one it finds. When your run Makefile.PL It will tell you which client it is useing.

the make file will hard code the full path of the libraries into the
binaries.


Yest that is how it works. But remember it tis the client libraries. OIC.dll for win and the .SO files for others

what happens when you need to create the dbi/dbd module for another system
that does not have the version of oracle on the system that has the IBM C
compiler?


Like I have said in the past you are compiling against a client not a database. In this case I would install the Oracle instant client http://www.oracle.com/technology/tech/oci/instantclient/index.html as it is compatiable (as are most clients) with almost any Oracle database and then compile your DBD::Oracle against this one.

You do not need an Oracle DB on you server to run DBD:ORACLE actully there are a large number of reasons why you would not want your Oracle DB and DBD::Oracle on the same box but I wount go into them here.

cheers John Scoles


.



Relevant Pages

  • Re: DBD-Oracle 1.19 with Oracle Instant Client 10.2.0.3 on Debian Etch wont install
    ... Currently all my Oracle inst client files are user oracle group oinstall yet lib bin and other dirs have 755 permission so root should be able to access and execute these softlibs. ... As I have written, I have installed DBD::Oracle-1.19 many times with a full client without problem, yet with the limited instant client it does not find the mk file, and the one mk file that the instant client installs does not work. ... It also gives me a makefile for DBD::Oracle but install and test fail ...
    (perl.dbi.users)
  • Re: DBD::Oracle / Instant Client segfaults
    ... I've been doing some more tests concerning this issue and it seems that it only appears with the combination of Oracle Instant client libraries, Perl configured with -Dusemymalloc on RHEL 3. ... When i run the script with the 'use Digest::SHA1;' line commented ...
    (perl.dbi.users)
  • Re: ORATCL help needed!
    ... set cursor ... Wow, An Oratcl 3.3. ... It is coded with the the OCI layer released with Oracle ... Oracle instant client is available for many many platforms, ...
    (comp.lang.tcl)
  • Re: ORATCL help needed!
    ... set cursor ... It is coded with the the OCI layer released with Oracle ... Oracle instant client is available for many many platforms, ... Did you compile Oratcl 3.3 for yourself. ...
    (comp.lang.tcl)
  • Re: DBD::Oracle 1.19 failing to make
    ... Your Oralce client 8.0.5.0.0 is most likly too old to use the latest version of DBD. ... There were a number of changes in the OCI for the 9x version especially in the area of Batch feeding and this is where you are getting your errors. ... Can you tell me which version of the Oracle client you are using as I also see a funny warning in that it cannot find SQL*Plus. ...
    (perl.dbi.users)