Problems with synonyms and PL

From: Joann Wright-Fisher <joannw_at_sr.hp.com>
Date: 1997/01/07
Message-ID: <5aum88$nci_at_canyon.sr.hp.com>#1/1


I am able to query a table named max_wip in sqlplus. However, when I try to access the same table using PL/SQL, I get the following error:

    PCC-S-0061 PLS-356
    'MAX_WIP' must name a table to which the user has access.

    The table max_wip currently has a public synonym of the same name.     If I specify the schema.MAX_WIP within the PL/SQL block, it works.     If I change the public synonym to a different name, it works.

    We have always made the public synonym the same as the table name.     I am consistently unable to access this table in PL/SQL.     It appears we have others that cannot be accessed by PL/SQL     depending on where they are embedded in a ProC program.

    Is there a rule that the synonym_name should not be the same as the     table_name? Why?
    Is this a bug?

    By the way, this is PL/SQL version 2.0     Oracle version 7.0.16.4
    SqlPlus version 3.1

JoAnn Wright-Fisher
MWTD Technical Data Management
email: joannw_at_sr.hp.com
phone: (707) 577-5213 Received on Tue Jan 07 1997 - 00:00:00 CET

Original text of this message