in reply to Re^2: DBD module.
in thread DBD module.

You know - saying something like that in your original post would have been helpful and saved you a day of waiting for the right answer.

Have you checked to see what $ENV{ORACLE_SID} is set to? That's what DBD::Oracle is looking for. If you absolutely need to, you can do something like: 

BEGIN {
    $ENV{ORACLE_SID} = 'db2';
}

use DBI;

my $dbh = DBI->connect( .. );

[download]
My criteria for good software:
  1. Does it work?
  2. Can someone else come in, make a change, and be reasonably certain no bugs were introduced?

In Section Seekers of Perl Wisdom