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