Problem with Oracle 10.2 and Perl dbd/dbi interface

------_=_NextPart_001_01C5F518.AC37117C
Content-Type: text/plain

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.



------_=_NextPart_001_01C5F518.AC37117C--

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@mail.va.gov]=20
Sent: Tuesday, November 29, 2005 2:21 PM
To: 'dbi-users@perl.org'
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'.
=20
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.
=20
=20

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

Can you tell us which version of perl you are running and wether it is 10.2
personal, enterprise or standard or is it just the client?


"Marty Martindale" wrote in message
news:2EC1D4C05D45BA46A4D057A709FA650B776D3A@VAAACEXC4...
> 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.
>
>
>