Public synonyms for Packages
executing the following using an explict owner, package name and package body name worked fine from user scott (privs are there):
exec stage_owner.RPT_CA_INVENTORY_AGING.GET_INVENTORY_AGING_SUMMARY
...it works!
Now
SCOTT> exec RPT_CA_INVENTORY_AGING.GET_INVENTORY_AGING_SUMMARY
does not work because of a lack of a synonym and lack of specifying the owner of the package.
How do I create a public synonym for a package.package_body ? The following public synonym was created as SYSTEM but SCOTT still cannot see the RPT_CA_INVENTORY_AGING.GET_INVENTORY_AGING_SUMMARY unless I specify the owner.
This worked syntactically but not during execution logged on as SCOTT:
create public synonym "RPT_CA_INVENTORY_AGING.GET_INVENTORY_AGING_SUMMARY" for
"stage_owner.RPT_CA_INVENTORY_AGING.GET_INVENTORY_AGING_SUMMARY"
Synonym created.
Re: Public synonyms for Packages
If you mean, 'package body' than, you can not create synonym only for package body.
Quote:
Originally posted by gopi
How do I create a public synonym for a package.package_body ?