From oracle-l-bounce@freelists.org Thu Nov 3 11:17:39 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id jA3HHcbg013473 for ; Thu, 3 Nov 2005 11:17:38 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id jA3HHavX013463 for ; Thu, 3 Nov 2005 11:17:36 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 69212214EDA; Thu, 3 Nov 2005 12:17:30 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 25732-04; Thu, 3 Nov 2005 12:17:30 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D5926214E8C; Thu, 3 Nov 2005 12:17:29 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 03 Nov 2005 12:15:34 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 51F03214B82 for ; Thu, 3 Nov 2005 12:15:34 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 25419-09 for ; Thu, 3 Nov 2005 12:15:34 -0500 (EST) Received: from imcsvr-2.aetvn.com (imcsvr-2.aetvn.com [216.89.67.159]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 23741214910 for ; Thu, 3 Nov 2005 12:15:34 -0500 (EST) Received: by imcsvr-2.aetvn.com with Internet Mail Service (5.5.2653.19) id ; Thu, 3 Nov 2005 12:15:33 -0500 Message-ID: <30462D80AA52E74698512ADCC4F7EAA32D74C2E6@exchange.aetvn.com> From: "Subbiah, Nagarajan" To: "'ORACLE-L'" Subject: RE: Privilege Issue Date: Thu, 3 Nov 2005 12:15:12 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5E09A.26616670" X-archive-position: 27990 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Nagarajan.Subbiah@aetn.com Precedence: normal Reply-To: Nagarajan.Subbiah@aetn.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-4.6 required=5.0 tests=BAYES_00,HTML_50_60, HTML_FONTCOLOR_BLUE,HTML_MESSAGE autolearn=no version=2.63 ------_=_NextPart_001_01C5E09A.26616670 Content-Type: text/plain Hi, I am getting an ORA-904 invalid identifier error when calling a package over the db link. Database D1 has a package P1 and Database D2 has the synonym S1 for the package P1 over the db link. When I call a function F1 in the package P1 using the synonym S1 from D2, "Select S1.F1('123) from dual; " I am getting the above error ORa-904. What privilege I am missing and Can we not access the package over the db link? Don't have any issue with accesing the tables. Thanks, Raja. ------_=_NextPart_001_01C5E09A.26616670 Content-Type: text/html Message
 Hi,
 
I am getting an ORA-904 invalid identifier error when calling a package over the db link.
 
Database D1 has a package P1 and Database D2 has the synonym S1 for the package P1 over the db link. When I call a function F1 in the package P1 using the synonym S1 from D2,
 
"Select S1.F1('123) from dual; " I am getting the above error ORa-904. What privilege I am missing and Can we not access the package over the db link?
 
Don't have any issue with accesing the tables.
 
 
Thanks,
Raja.
------_=_NextPart_001_01C5E09A.26616670-- -- http://www.freelists.org/webpage/oracle-l