Trying to load DBD::Oracle

Fairchild has asked for the wisdom of the Perl Monks concerning the following question:

Hi,

I have a small perl snippet that I have trying to run. I have oracle instant client set up on my box and I can connect to it as the command line.

BEGIN
{
 $ENV{ORACLE_HOME} = "/opt/oracle/instantclient_11_2";
$ENV{LD_LIBRARY_PATH} = "/opt/oracle/instantclient_11_2";
}
 
use DBI;
use DBD::Oracle;
[download]

Cant load '...Oracle.so' for module DBD::Oracle: libclntsh.so.11.1: ...

Yet if I set these environment variables on the command line and then run the program it's fine. So what I don't get is that I thought the BEGIN{...} block runs before the use statements (given it's location) so why isnt the environment taking effect?

Fairchild.

Comment on Trying to load DBD::Oracle Download Code

Replies are listed 'Best First'.
Re: Trying to load DBD::Oracle by Anonymous Monk on Aug 28, 2011 at 11:14 UTC
LD_LIBRARY_PATH must be set before you launch perl So if you want to set LD_LIBRARY_PATH from inside perl, you have to relaunch your script See Re^5: replicating the command 'unset LIBPATH' in perl	[reply]
Re: Trying to load DBD::Oracle by runrig (Abbot) on Aug 29, 2011 at 05:16 UTC
See also Set LD_LIBRARY_PATH and restart program and the related links and followups.	[reply]
Re: Trying to load DBD::Oracle by djp (Hermit) on Aug 29, 2011 at 04:51 UTC
See also Re^4: Modifying %ENV From The Shebang Line	[reply]