Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Synonyms for packages
I like to create public synonyms for procedures, functions, packages, etc. With packages remember that you can create a synonym for the package but not for the individual functions or procedures within the package. Invocation is via SYNONYM_NAME.PACKAGE_ELEMENT.
-- Thomas W. Vanya Oracle and OracleRdb Database Administrator Eastman Chemical Company ------------------------------------------------------------------------- (Due to proliferation of spammers, remove nospam from address.) Mark Aurit <mark_aurit_at_mail.northgrum.com> wrote in article <01bd04d3$c7edc160$3d846380_at_NGW20072982.dssd.northgrum.com>...Received on Tue Dec 09 1997 - 00:00:00 CST
> What is the best way to make my package available to other people? Would
it
>
> be to make my package spec a public synonym? Or do I also need to make
> the procedures in my package body public synonyms?
> Thanks, Mark
> mark_aurit_at_mail.northgrum.com
>