Public synonyms for Packages

[gopi]

Originally posted by jmodic
You have mixed up few things. Package and package body always have the same name.

packaged procedure (not package body) = GET_INVENTORY_AGING_SUMMARY

Yes, Yes! Thank you Jurij!

Your create synonym statement should be:

create public synonym RPT_CA_INVENTORY_AGING for
stage_owner.RPT_CA_INVENTORY_AGING;

Now your users will be able to reference those packaged procedures and functions without specifying schema name, eg

SCOTT> exec RPT_CA_INVENTORY_AGING.GET_INVENTORY_AGING_SUMMARY

Thank you again Jurij...I'm now past my mental block!