Re^2: DBD module.

Replies are listed 'Best First'.
Re^3: DBD module. by dragonchild (Archbishop) on Apr 21, 2006 at 12:50 UTC
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: Does it work? Can someone else come in, make a change, and be reasonably certain no bugs were introduced?	[reply] [d/l]

Replies are listed 'Best First'.

Re^3: DBD module.
by dragonchild (Archbishop) on Apr 21, 2006 at 12:50 UTC

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:

Does it work?
Can someone else come in, make a change, and be reasonably certain no bugs were introduced?

[reply]
[d/l]