Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Synonyms for packages
What I did was created a public synonym for the package. This hides the schema that owns the package. Then refer to your procedures and functions in your package as PKG_SYNONYM.PROCEDURE or PKG_SYNONYM.FUNCTION
In article <01bd04d3$c7edc160$3d846380_at_NGW20072982.dssd.northgrum.com>,
mark_aurit_at_mail.northgrum.com says...
>
>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
Received on Tue Dec 09 1997 - 00:00:00 CST