RE: Problem with Oracle 10.2 and Perl dbd/dbi interface



Just to get more information, I presume you are talking about the
ActiveState perl and DBD::Oracle installed via ppm from their site? I'm
also presuming you installed the Oracle Instant client along with (which
they do now, but you can skip it, if you have the full client).

Please confirm, so we have better information. I have installed their
client, but said "no" when they went to install the instant client...and
I don't (yet) seem to have problems (other than the new Database install
on Windows injects PERL5LIB environment variables which screws up my
configuration badly...)

Regards,

Jeff

-----Original Message-----
From: Martindale, Marty (NGIT) [mailto:Charles.Martindale@xxxxxxxxxxx]
Sent: Tuesday, November 29, 2005 2:21 PM
To: 'dbi-users@xxxxxxxx'
Subject: Problem with Oracle 10.2 and Perl dbd/dbi interface

There is a problem in Oracle 10.2 that surfaces after you install the
latest
Perl, dbd-oracle and dbi on a windows box. The symptom is that sqlplus
and
sqlplusw no longer function, they return almost immediately to the
command
prompt. This is a know but undocumented problem in oracle. I submitted
a
tar to get the information. The problem file is 'oraociei10.dll' was
not
compiled at the correct level. Renaming this file will get sqlplus and
sqlplusw functioning again. The file is located in Perl\bin'.

There is also a problem with the dbi installation if you have blanks in
the
path name. The symptom of this is an error message when the license
agreement is being displayed.


.



Relevant Pages

  • Re: attempt to build 64 bit on Solaris fails
    ... > libraries needed to link with a 64-bit Tk. ... We were running a 32-bit version of Perl ... > Each section below is a summary of the commands used to install it. ...
    (comp.lang.perl.tk)
  • Re: attempt to build 64 bit on Solaris fails
    ... libraries needed to link with a 64-bit Tk. ... We were running a 32-bit version of Perl ... Each section below is a summary of the commands used to install it. ...
    (comp.lang.perl.tk)
  • Re: DBD::Oracle Install Mystery
    ... getting trying to install DBD::Oracle: ... Looking at your compile line above I'm guessing you are using Oracle 8.1.6 and that OCI_FETCH_CURRENT was not available in 8.1.6)or at least not defined). ... get a recent instant client and instant client sdk and compile DBD::Oracle against that. ... Perl 5.10 recently installed with gcc, ...
    (perl.dbi.users)
  • RE: Trying to make DBI work for me
    ... I did "perl -V"; ... say "Oracle client", do you mean DBD-Oracle.ppd? ... Install 'DBD-Oracle' version 1.15 in ActivePerl 5.6.1.633. ... I don't know about the perl error, but as for the Oracle error, it ...
    (perl.dbi.users)
  • (Fwd) DBD module install problem
    ... I downloaded and built from source the lastest Perl from CPAN. ... I built it with gcc compiler which was built as a 64 bit binary. ... I was able to add the DBI module for Oracle, with no problem, but when I during the make of DBD I get this warning and an error message, and am unable to install it. ...
    (perl.dbi.users)