Oracle database link error - ppm upgrade problem

From: Tony Adolph (Tony.Adolph_at_o2.com)
Date: 07/29/04


To: "Reidy, Ron" <Ron.Reidy@arraybiopharma.com>
Date: Thu, 29 Jul 2004 17:15:47 +0200


Hi Ron,

Thanks for the feedback, but the queries are only:

      select * from global_name@CSC_T.BGENDB1
and
      select object_name FROM user_objects@CSC_T.BGENDB1 WHERE
object_type ='SYNONYM'

which obviously work from sqlplus, so that's why I suspect the
DBI/DBD-Oracle. There are no alert logs errors, even when perl/DBI croaks
on the query.

Regards
Tony



Relevant Pages

  • Re: Mahler 6 recordings survey
    ... listening to Mahler's version. ... Hah. ... I suspect that 'allows' above is intended as a synonym for 'causes'. ...
    (rec.music.classical.recordings)
  • Synonyms and Oracle permissions
    ... create synonym str_array for owner.str_array ... If I look at this in sqlplus, I can see that the synonym exists: ... SQL> describe str_array; ... So how do I grant USER access to all of OWNER's objects? ...
    (comp.databases.oracle.misc)