Problems with synonyms and PL
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