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: How can i create a valid Synoynm for a Function in a package

Re: How can i create a valid Synoynm for a Function in a package

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/05/04
Message-ID: <957445778.26841.0.pluto.d4ee154e@news.demon.nl>#1/1

You can't
Synonyms are on object level, function in a package is not an independent object.

Hth,

Sybrand Bakker, Oracle DBA

Karl R. <kreitsch_at_zdnetonebox.com> schreef in berichtnieuws 1cdad320.bc4bec72_at_usw-ex0104-031.remarq.com...
> ORACLE 7.3.4.1
>
> How can i create a valid Synoynm for a Function in a package
>
> I want to create a synonym for the
> PPA_UTIL.F_GET_SYSDATE_DATE_ONLY - Function, so that its
> implemented in the PPA_UTIL - Package but can called as a global
> Function without package-prefix
>
> SQL> create synonym F_GET_SYSDATE_DATE_ONLY FOR
> S2000.PPA_UTIL.F_GET_SYSDATE_DATE_ONLY;
> create synonym F_GET_SYSDATE_DATE_ONLY FOR
> S2000.PPA_UTIL.F_GET_SYSDATE_DATE_ONLY
> *
> ERROR at line 1:
> ORA-00933: SQL command not properly ended
>
> Karl Reitschuster
> Senior Consultant CSC Ploenzke AG
> Oracle Databases, Implementation, Performance-Tuning
> <!Jesus is Lord!>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
 *
> The fastest and easiest way to search and participate in Usenet - Free!
>
Received on Thu May 04 2000 - 00:00:00 CDT

Original text of this message

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