Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

unable to call package through public synonym

406873Dec 19 2003 — edited Dec 23 2003
Hi,

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 20 2004
Added on Dec 19 2003
9 comments
655 views