Re: Oracle9i and Perl.

I've compiled DBD::Oracle earlier - from source, on Windows NT 4. It uses OCI (Oracle call interface) and on-site installation requires the same Oracle client version as at compile time. This means that if you compiled DBD::Oracle on a machine having the Oracle 8i client and OCI libs installed, the target machine will need to have the same installation. The Perl version I used is IndigoPerl 5.6.0 (www.indigostar.com), which is a convenient Win32 compilation of the Perl interpreter along with standard libs and many additional modules. The C compiler I used is MS Visual C++ 6.0. I've found that version 1.06 of DBD:Oracle can only be compiled against Oracle OCI version 8.0. For OCI version 8i you will need DBD::Oracle 1.12, which in turn cannot use OCI 8.0. I have not yet tried Oracle 9i. The DBI module's version I use is 1.21.

Compilation generates basically the following files: <Perl-dir>\site\lib\auto\DBD\Oracle\Oracle.dll <Perl-dir>\site\lib\DBD\Oracle.pm
I could mail them if you are interested (elwood_at_fame-online.de) To use them you will need to have a Oracle 8i client installation including OCI libs.

The ppm module you named is probably part of ActiveState Perl. They had not upgraded to DBD::Oracle 1.12 the last time I checked that out (some months back).

hej då!
elwood

George Barbour schrieb:
>
> Oracle9i 9.2.0.1.0.
> Win NT 4.0
> I am working through 'Perl for DBA's' by Duncan and Still.
> Has anybody used the DBD::Oracle Perl Module to access an Oracle9i database?
> or managed to install DBD without the 'ppm' module, which doesn't seem to be
> included in the install.
>
> George Barbour.
Received on Fri Feb 28 2003 - 13:16:24 CST