I am using DBI with Oracle on linux with apache.
I have been using an older version of Oracle.pm with DBI form some time.
Oracle.pm,v 1.77
I always used a connection like this:
$roster_conn = DBI->connect('dbi:Oracle:DBNAME',$dbuser,$dbpwd)
or die "connect failed" . DBI->errstr;
where $dbuser is formattted as username@schema
and it worked fine.
I recently upgraded and started using a newer version, Oracle.pm,v 1.92
Then my programs started breaking.
What seemed to be happening is when Oracle.pm was setting its $user
variable it was appending @DBNAME onto the end of my $dbuser variable,
so to make it work, I had to take the "@schema" off and just set $dbuser
to username. Now it assembles all the pieces and seems to work.
I havent been able to find a specific change in the modules to cause
this, although I am sure my searching was not exhaustive...
So, I guess the question is, did I really have to do this or did it
break because I missed picking up another new module that I should have
with these pieces? Or was I doing it wrong all along and just lucky it
worked the other way at all?
Just curious.
Barb
