I've recently upgraded from Oracle 7.3.4.4.1 to 8.0.6.2.0 (and DBD
as well). After doing so, I noticed that the following connect
string (which used to work fine) no longer works for remote databases:
$dbh = DBI->connect('dbi:Oracle:@DB','username','password');
but the following still does:
$dbh = DBI->connect('dbi:Oracle:','username@DB','password');
Does anyone know if this is a change in DBD::Oracle between 0.47 to
1.06 or a change in SQL*Net from 1.x to 2.x? I'm suspecting that
it's no longer handled in DBD::Oracle given the code fragment from the
connect sub:
if (DBD::Oracle::ORA_OCI() >= 8) {
$dbname = $1 if !$dbname && $user =~ s/\@(.*)//s;
}
but the OCI 7 code later on appears to handle that case. This tells me
that for Oracle 8+ the remote database indicator must be in the form
"username@DB".
Also as a minor note, has anyone else noticed the "Y2K bug" result
in the blib/man3/DBD::Oracle.3 file of the distribution? The
date in the file is "14/Jul/100".
Doug Secord
[EMAIL PROTECTED]
