Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How can i create a valid Synoynm for a Function in a package
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