in reply to %ENV and DBI

You're probably setting them too late. Do it in a BEGIN block before the "use DBD::Oracle" line.

Replies are listed 'Best First'.
Re^2: %ENV and DBI
by Anonymous Monk on Mar 28, 2008 at 16:17 UTC
    Thank you, perrin. I tried this:

    #!/usr/bin/perl
BEGIN {
    #$ENV{'ORACLE_HOME'}  = '/path/to/orahome';
    #$ENV{'LD_LIBRARY_PATH'} = '/path/to/orahome/lib';
    system("export ORACLE_HOME=/path/to/orahome");
    system("export LD_LIBRARY_PATH=/path/to/orahome/lib");
};
use DBI;

    [download]
    I still get the error using the two system calls or the two $ENV assignments. Any other thoughts?
[reply]
[d/l]

      Because you've commented out the two lines that might have done something and instead started two subshells in which you modify the environment (and then those subshells promptly exit making no difference whatsoever in the parent or any of its descendants).

      The cake is a lie.
      The cake is a lie.
      The cake is a lie.

[reply]

In Section Seekers of Perl Wisdom