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.