Hi there,
What exactly do you mean by "Upgrading Oracle.pm". Usually only the whole
distribution of DBD::Oracle has to be upgraded, not only the perl
specific Oracle.pm,
as a whole bunch of Perl XS code is also involved. So be sure to upgrade the
DBD::Oracle module-package (best with CPAN or CPANPLUS)
The latest DBD::Oracle might need a newer version of DBI than you
currently have
installed, so be sure that DBI is up to date too, when DBD::Oracle complains
(CPAN will do this for you)
If you have exactly done the above, than take a look at the README or
CHANGELOG
of DBD::Oracle, there is stated that this should still work, but you
should make sure TWO_TASK
environment is not set (it might confuses the connect)
Cheers
+rl
If you have not upgraded the whole DBI
Barbara Lindsey wrote:
> 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
>
>
>
>
--
+rl
-------------------------------------
Roland Lammel
-------------------------------------
Services / Technical Assistance / PPA
Kapsch CarrierCom
Triesterstr. 70a, 1102 Wien
-------------------------------------
mailto:[EMAIL PROTECTED]
Tel: +43 1 60501 - 3456 (ESN 572 3456)
Fax: +43 1 60501 - 3405
Mobil: +43 664 628 - 3456
-------------------------------------
