Skip Menu |

This queue is for tickets about the Perl-Dist-Strawberry CPAN distribution.

Report information
The Basics
Id: 48796
Status: resolved
Priority: 0/
Queue: Perl-Dist-Strawberry

Owner: Nobody in particular
Requestors: kmx [...]

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)

Subject: DBD::Oracle support
Download (untitled) / with headers
text/plain 1.8k
Hi, I was surprised how easily it is possible to install DBD::Oracle support into strawberry perl. As saying "strawberry supports Oracle DB" sounds appealing (at least from marketing point of view) I have created this post with a proposal to include DBD::Oracle support into strawberry release. What I am proposing is "MySQL way" that means including already compiled and installed perl module with all required DLLs. So how you can install DBD::Oracle: 1) From download the following - Instant Client Package - Basic Lite (approx. 17MB) - Instant Client Package - SDK (approx. 1MB) (currently version 2) Unpack both into e.g. d:\ora\instantclient_11_1 3) Download and unpack DBD-Oracle-1.23 (e.g. into c:\build\DBD-Oracle-1.23) 4) Build and install steps: set ORACLE_HOME=c:\ora\instantclient_11_1 set PATH=%PATH%;c:\ora\instantclient_11_1 (the previous 2 sets you need just for building not for using) Show quoted text
cpan> look DBD::Oracle
perl makefile.PL -V dmake dmake install copy c:\ora\instantclient_11_1\oci.dll D:\cfgaudit\_\strawberry\perl\site\lib\auto\DBD\Oracle\oci.dll NOTE: of course you can run tests - you will need some running Oracle DB And the most interesting is that it not only installs quite easily it also works :) The only thing I am not sure about is copying OCI.DLL from Oracle Instant Client into strawberry distribution. However according the licence agreement I guess it might be possible (of course including the license agreement into c:\strawberry\licenses). Somebody has to check whether it is legal to take OCI.DLL from Oracle Instant Client (I am neither a native english speaker/reader nor a lawyer). I want to do more testing with real DB - I will post my results here. -- kmx
Download (untitled) / with headers
text/plain 594b
Testing against real Oracle 10g release 2 revealed: 1) DBD::Oracle really works :) 2) Oracle Instant Client Light is not enough if you want to talk to DB with exotic NLS_CHARACTERSET (like my database). So we have to use Full Oracle Instant Client. 3) oci.dll is not enough - for "exotic" charset support you will also need at least oraociei11.dll (117MB!!) from Full Oracle Instant Client To sum up: - my original idea was wrong - DBD::Oracle means: 1) 100MB+ of Oracle DLLs; 2) license problems So we should probably put Oracle@strawberry off for a while. Sorry for useless RT. -- kmx
(Setting this to stalled until can do better)

This service is sponsored and maintained by Best Practical Solutions and runs on infrastructure.

Please report any issues with to