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

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

From: Karl R. <kreitsch_at_zdnetonebox.com>
Date: 2000/05/04
Message-ID: <1cdad320.bc4bec72@usw-ex0104-031.remarq.com>#1/1

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