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: DBI & DBD::Oracle
    ... My guess is you do not have the correct Oracle environment set up. ... But I don't understand why I can connect & select from SqlPlus ... but not even Connect with DBI? ... which is the sameconnection I'm using with DBI. ...
    (perl.dbi.users)
  • Re: Using the DBI to connect to an Oracle server w/o connecting to a database
    ... The point of DBI is that it provides a perl ... x> want to feed a text file through sqlplus with no interaction, ... that with SQL statements passed to DBI, you need to do a new connect. ...
    (comp.lang.perl.misc)
  • RE: :Oracle install problem On Solaris 8
    ... Sqlplus doesn't run properly. ... To: Hemanth Kumar ... Subject: RE::Oracle install problem On Solaris 8 ...
    (perl.dbi.users)
  • Oracle client
    ... I have just downloaded Oracle 10.2 XE for Debian x86 and installed it. ... I can connect to the database instance using SQLPlus and everything is ... From reading the documentation it appears I should install ... but just to get SQLPlus I have to download and install just under ...
    (comp.databases.oracle.server)
  • Re: Oracles RPAD problematic via Perls DBI module
    ... > use DBI; ... > This problem occurs only for a blank string. ... > If I run the query via sqlplus: ...
    (comp.lang.perl.misc)