Did you recompile DBD::Oracle since Oracle 9.2 was installed?
>>> "Richard Freedman" <[EMAIL PROTECTED]> 08/10/04 07:52PM
>>>
Our DBA has recently upgraded Oracle from 8.1.7 to 9.2. I tried
changing my ORACLE_HOME enviornment and it broke my DBI/DBD::Oracle.
If I run
$ENV{ORACLE_HOME} = "/opt/oracle/products/8.1.7";
$db = DBI->connect ("dbi:Oracle:xxx", "uname", "pword",
{AutoCommit=>0});
all is well
If I run
$ENV{ORACLE_HOME} = "/opt/oracle/products/9.2";
$db = DBI->connect ("dbi:Oracle:xxx", "uname", "pword",
{AutoCommit=>0})
or croak "Database Error: $DBI::errstr\n";
I get DBI->connect(xxx) failed: ERROR OCIEnvInit
I am running Sun Solaris, Perl 5.6.1, DBI 1.20, DBD::Oracle 1.12
Please help.
Richard Freedman
Bioinformatics Scientist
Cytokinetics
(650)624-3027
