Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Synonyms for packages

Re: Synonyms for packages

From: Michael A. Rife <MRife_at_admin.usf.edu>
Date: 1997/12/09
Message-ID: <66kajr$550$1@news.usf.edu>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US