unable to call package through public synonym
406873Dec 19 2003 — edited Dec 23 2003Hi,
I am having trouble executing a procedure from a public synonym of a package in another user.
I created the synonym with the following statement:
create or replace public synonym sympackage for owner1.packagename;
If I use the fully qualifier name (eg. owner1.packagename.procedurename), it works ok but if I use the public synonym (EG. sympackage.procedurename) it will come up with an error like this:
identifier 'SYMPACKAGE.PROCEDURENAME' must be declared